Search for " or - in a field

shaggy

Registered User.
Local time
Today, 15:52
Joined
Sep 9, 2002
Messages
41
I have a field that has either a quotation mark or a hyphen as part of the field.

It would look like this.

9-153807
or
3" 503279

My question is how do I search for either a quotation mark or a hyphen in a field to separate the two types of entries represented above?
 
Drag the table field to a column in the query grid, and type the Criteria:-

Like '*"*' Or Like '*-*'
 
Thanks for the help Jon.
 

Users who are viewing this thread

Back
Top Bottom