A query to delete a portion of a field?

[JJman]

How would I go about changing all the values in a field with alpha-numerics to remove the dashes (i.e. to change entries like BR-312-8212 to BR3128212)? Thanks!

 

[jrbarnett]

Hi,

If they are all in the same format, I would use an Update SQL statement with the Mid$ function to extract the appropriate sections of the data.

John

 

[PaulBricker]

You can look at the Replace Function. In a module you would put
Fuction myfunction(myval as String) as String
myfunction = Replace(myval,"-","&quot
End Function

Then in a query you could put

MyField:myfunction([FieldName])

This would give you
BR3128212

as the return value for your example.

Paul