I have a database to which I import names and other information about businesses and then export the data as delimited txt files. Users are very bad about putting restricted characters in the name field for businesses. One of the services that I export to is very fussy about only certain characters being in the name field (specifically they allow only:
A-Z
a-z
0-9
&
- (hyphen)
space
I'm trying to figure out a way I could use a query to identify any record that had something other than these characters in the name field.
A-Z
a-z
0-9
&
- (hyphen)
space
I'm trying to figure out a way I could use a query to identify any record that had something other than these characters in the name field.