Query -- Not like multiple numbers

akb

Registered User.
Local time
Yesterday, 22:58
Joined
Jul 21, 2014
Messages
57
I am overthinking this and need some help.

I'm trying to filter my query to not pull a few different values from one column. When I enter thee criteria Not Like '*25*' the query does not pull through rows that have 25 in this column. How do I tell it to not pull multiple numbers?

This is not working, because I'm thinking this is for the text format - correct?
Not Like ‘*25*’ and Not Like ‘*26*’ and Not Like ‘*54*’ and Not Like ‘*77*’ and Not Like ‘*91*’

Thanks for your help!
AKB
 
like will work with numbers in sql

This is not working, because I'm thinking this is for the text format - correct?
Not Like ‘*25*’ and Not Like ‘*26*’ and Not Like ‘*54*’ and Not Like ‘*77*’ and Not Like ‘*91*’
if this is how you have your code then no, it won't work like that it needs to be

Code:
 myfield Not Like ‘*25*’ and myfield Not Like ‘*26*’ and myfield Not Like ‘*54*’ etc
Not you seem to have some strand single quotes - should be '
 
where [yourFieldName] Not In (25, 26, 54, 77, 91)
 
Thank you for your response. Where am I putting this? When I put it in criteria, it does not work.
 
you said

I'm trying to filter my query to not pull a few different values from one column. When I enter thee criteria Not Like '*25*' the query does not pull through rows that have 25 in this column. How do I tell it to not pull multiple numbers?
so where do you think you would put it?

When I put it in criteria, it does not work.
I wonder why not, it might have something to do with you describing an issue in broad terms and getting a broad response in return
 

Users who are viewing this thread

Back
Top Bottom