Re: LIKE with an IN

In article <4dh7at$92c_at_su102w.ess.harris.com>, spatters_at_harris.com (Stuart Patterson) writes:
>
> 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.

TRY

	WHERE NAME LIKE '%XXXXXX%'
	OR NAME IN ('NAME1','NAME2','ETC')

>
> Thanks.
>
> Paul Tomasura
> ptomasur_at_harris.com
>

-- 
Bye for now.
Steven C.
--------------------------------------------------------------------------------
Steven Champness                   champs_at_cbr.hhcs.gov.au
Dept of Human Services & Health    Brisbane, Queensland, Australia
These opinions are volatile and should be stored below 4 degrees Celcius