add a space between set characters

  • Thread starter Thread starter Monica
  • Start date Start date
M

Monica

I would like to add a space between the 2nd and 3rd
character in a field for all records in a table. I
believe this can be done through a string command, but not
sure how. An example of what I'm trying to do is:
"MW2-16" and I need it to read "MW 2-16"

Thanks
 
This UPDATE query should do it:

UPDATE MyTable SET MyField = Left(MyField,2) & " " & Mid(MyField,3,999);
 
Create an Update Query and us the following as the "Update To" valu
...

Left([FieldName],2) & " " & Mid([FieldName],3)

RD
 
Back
Top