Re: LIKE with an IN

spatters_at_harris.com (Stuart Patterson) wrote:

>Does anyone know how I can combine the operators LIKE and IN? I have a string
>array of names that I want to do a select on. I can use IN and the select
>will find all the matches. I would then like to perform wildcard(%) selects
>so I need to use LIKE. However, the LIKE operator only allows me to perform a
>select based on 1 value (not on an array of names). Is there an operator that
>will combine the functionality of a LIKE and IN so that I can select on
>partial name and full names at the same time.

It's called 'OR'. :-)

WHERE x LIKE '%pattern1%'
OR x LIKE '%pattern2%'

etc.

HTH

--
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!