Posted by rcamarda on 10/10/05 15:59

I can use the IN with the WHERE clause as example:

SELECT * FROM NORTHWIND WHERE LASTNAME IN ('FULLER','KING')

I want to use the IN and LIKE at the same time:
SELECT * FROM NORTHWIND WHERE LASTNAME LIKE ('A%','B%')

I know this is a simplistic example, but the members for the IN will be
many, 5 to 10.
I'm trying to avoid:
SELECT * FROM NORTHWIND WHERE LASTNAME LIKE 'A%' OR LASTNAME LIKE 'B%'
OR LASTNAME LIKE 'FU%' OR LASTNAME LIKE 'JON%' <...>

and so forth.
Any Ideas?
TIA
Rob

• Next in forum: Sql Server backup vs HP Data Protector (HPDP) -- Do *not* use SQL Server?
• Prev in forum: Re: database in simple mode yet txn log file can be out of diskspace ?
• Thread view: LIKE and IN can I combine

[Reply to this message]