Select ...where item is not like ...syntax problem 1

[RSX02]

Hi
I'm trying to do a request that bring me all record that is not like specific values.

I don't want that the items that looks like "Hardware", "Installation", "Programming" be in my request.
Something like
Select * from TblItem where Item is not like "Installation" and not like "Hardware"...etc...
Could you help me with the Syntax please.
Thanks in advance

 

[dan1967]

When you use [NOT] LIKE, you need a wildcard character because SQL is looking for something that contains whatever your input is.

Select * from TblItem where Item is not like "Installation%" and Item not like "Hardware%"

The "%" sign is the wildcard of choice for this expression. After your AND, you have to identify Item again for the next "Not Like".


Dan.

 

[djinn01]

Select * from TblItem where (Item not like '%Installation%'
and Item not '%Hardware%') and (other filtering conditions not related to the not like clauses, if any)

 

[RSX02]

So how can I transform this line?
Set RsItem = MyConn.Execute("select * from TblItem where ManufacturePartN is not like" & "Hardware%&quot

Thanks again

 

[RSX02]

Set RsItem = MyConn.Execute("select * from TblItem where (ManufacturePartN not like '%HARDWARE%') and (ManufacturePartN not like '%INSTALLATION%')&quot

This is working
Thanks

 

[SQLBill]

Have you considered using NOT IN:

Select * from TblItem where Item NOT IN ('Installation', 'Hardware', 'Programming')

-SQLBill