How do I remove a dash?

H

hidden_intuition

I need to take out one dash out of a group of letters and dashes. Examples
are things from A-2, B-3-5-2, or even 12-7-4. I need the first dash taken out
of my entire database. Is there any type of query or anything to take this
out?
 
D

Douglas J. Steele

You could use the following in a query:

Left([MyField], InStr([MyField], "-") - 1) & Mid([MyField], InStr([MyField],
"-") + 1)

If you wanted to make the change permanent, you could use that in an Update
query.
 
Top