SQL statement - what's wrong?

[Tapper]

Why doesn’t this pretty simple SQL statement work? I’m trying to get all Projects from Purchasing table where Program is P3233 and where Project doesn’t have ‘SW’ at the end. Any ideas?

SELECT Purchasing.ItemID, Purchasing.Project
FROM Purchasing
WHERE (Purchasing.Program='P3233') AND (Purchasing.Project<>'%SW')

 

[Juan Pablo González]

Change

(Purchasing.Project<>'%SW')

to

Not (Purchasing.Project Like '%SW')

 

[NateO]

Another possibility:

Right$(Purchasing.Project,2)<>"SW"

 

[Tapper]

Thank you guys!

I followed Juan Bablo's advise and got it solved. Thank you also for you, NateO, for giving an extra alternative.

This forum has really been a great help for me for the short time I have been a member. I hope some day I will be able to help others as well :wink: