Re: LIKE with an IN
From: Chuck Hamilton <chuckh_at_ix.netcom.com>
Date: 1996/01/26
Message-ID: <4eb44l$2aq_at_cloner3.netcom.com>#1/1
Date: 1996/01/26
Message-ID: <4eb44l$2aq_at_cloner3.netcom.com>#1/1
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!Received on Fri Jan 26 1996 - 00:00:00 CET