remove character from string

N

Nigel

I have a field and in the field I want to remove the - symbol where it
appears so if the fiels is 1234-5678 what function can I use to make it
12345678 remembering that in another record it could be 12-345678

thanks
 
J

Jerry Whittle

Not remove. You want to replace!

Replace("1234-5678","-","")

In a query it would look something like:

NoDash: Replace([TheFieldName],"-","")
 
Top