How do you query multiple strings in MS Access
Posted on 2011-03-16
I am querying multiple tables and I need to query for multiple strings e.g. "*zh" or "blaa*" or "frr*"
this is what I am curently using...
SELECT l_nbr, count(1) AS cnt
FROM (select * from 0219 where l_nbr like "*zh"
select * from 0220 where l_nbr like "*zh"
) AS x
GROUP BY l_nbr;