Update Query: Insert a space into a String (1 Viewer)

Randomblink

The Irreverent Reverend
Local time
Today, 10:33
Joined
Jul 23, 2001
Messages
279
I have a field that stores Alphanumeric characters.
It has a limit of 18 characters.
I want to run an Update Query.
I want the Query to insert a space into the 5th spot.

In other words:

The current listing looks like:

FIELD
ES-98-00
ES-87-14-A
ES-83-45
ES-78-13

(just a random assortment)
I wanna run the query so they now look like:

FIELD
ES-98 -00
ES-87 -14-A
ES-83 -45
ES-78 -13

Can you help me out?!
 

Rob.Mills

Registered User.
Local time
Today, 11:33
Joined
Aug 29, 2002
Messages
871
In the update type:

Left([FieldName],5) & " " & Mid([FieldName],6)
 

Users who are viewing this thread

Top Bottom