Removing dashes from a field

[JC Newsgroup]

Using:
Windows 98
Access 2002


I have a text field that shows SSN's like this:
111-11-1111
I want to remove the "-". What is the best way? An update query?

Thanks in advance!

 

[dimwit]

built a function like this and on use it on your update query

Function ReplaceQ(pString1 As String, pFind As String, pReplacement As
String) As String

ReplaceQ = Replace(pString1, pFind, pReplacement)

End Function