remove character from string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Not remove. You want to replace!

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

In a query it would look something like:

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