General information
Title:
Exclude select records with wildcards
I am using VB6 ADO to retrieve records from an Access DB. Withing this query, I need to exclude certain records. The field for exclusion is a text field used to store phone numbers.
If for instance, I want to exclude calls to the number (111) 222-3333, I can put that into the query and it works fine. But, if I want to exclude all the calls to the (111) area code.....I cant get it to work using any of the following....(111)*.....(111)%.....(111) ???-????.
Any suggestions?
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only