How do I exclude if text string inside string - ACCESS

W

Wheelz

In query design, for a certain column, I need to exclude all records
where the string "CDMA" appears anywhere in the string. Not sure how
to specify this??

Thank you

Wheelz
 
R

RoyVidar

Wheelz said:
In query design, for a certain column, I need to exclude all records
where the string "CDMA" appears anywhere in the string. Not sure how
to specify this??

Thank you

Wheelz
Click to expand...
Try

not like "*CDMA*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using query Wizard 2
insert spaces in string 0
How do I exclude records based on first two characters in cell 6
Is there no "AND" function in Access like in Excel? 2
Exclude Null Values/records from Report 1
Query criteria - exclude data and return all records if null 3
Run a Query that Excludes Values in A Table 4
VBA: How can I use a string variable as autofilter criteria? 4

Top