Contains and Like

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with the following values

Item No
123
123-AI
SFR
SFR-AI

I want to create a query that will pull up only records that contain AI in
the item number. How would I do this?

Thanks in advance for your help

Rob
 
Hi,


WHERE [Item No] LIKE "*a1*"


or


WHERE [Item No] LIKE '%a1%'



With JET, traditionally, the wildcard is * (and ?), but under some setting,
it can be % (and _ ) instead.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top