Re: SQL: Combine LIKE and IN statement?

Bob wrote:

> Can anyone tell me how to improve the following:
>
> Select tbl.city
> From tbl
> Where tbl.city like 'B%' or
> tbl.city like 'G%' or
> tbl.city like 'R%'
>
> I was trying:
> Where tbl.city like in ('B%', 'G%', 'R%')
> But apparently this is not the right way.
>
>
> Thanx,
> Bob

Perform an OR expansion.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)