How to Combine LIKE and IN

External Since: May 13, 2008 Posts: 3

SQL Server 2005.

I want to do a query that will accomplish both a LIKE type search and an IN
type search. I have a variable number of LIKE strings that I want to search
on. I know I can say:

SELECT * FROM <TABLE> WHERE <FIELD> LIKE '0001%' AND <FIELD> LIKE '0002%'
AND <FIELD> LIKE '0003%'

Is there a way to shorten this select statement and still accomplish the
same search? Thanks for any help.
--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org

External Since: May 13, 2008 Posts: 3

I should have put OR in my example as:

SELECT * FROM <TABLE> WHERE <FIELD> LIKE '0001%' OR <FIELD> LIKE '0002%' OR
<FIELD> LIKE '0003%'