I am writing an access application for our company and have come across a problem thats been bugging me.
i need to do a like statement for 2 values in the same field
example i need to select products with the prefix 01 and 21
i tried this
SELECT ItemNumber FROM tblProducts WHERE ItemNumber Like '01*' AND ItemNumber Like 21
but it didnt work when i do a like with just 01 or just 21 it works fine, is there a way i can filter it by just these two?