Removing "-" from text string

Judy

Registered User.
Local time
Today, 21:38
Joined
Sep 26, 2000
Messages
34
I'm working on an inventory list that seems to have duplicate values in the SNs because a dash (-) was entered in the string on some records, not on others. What function do I use to remove the dash in a query to view duplicates? Most records in question are in the format of 00-0000, but some are longer, 0000-00000. Thanks for any help provided!!
 

Users who are viewing this thread

Back
Top Bottom