I have a select stmt in access like the following. if I use 'in' it gives me all the records as long as it match one specialty in the string. Is there anyway to make it match all the specialty in STRING. I know I can use '=', but my problem is my STRING is so long and I really don't want split it.
select tbl1.* from tbl1 where tbl1.specialty in (STRING);
below is some sample data for tbl1
002 Interior design
002 parking lot