Re: Combine LIKE and IN statement?

From: Ron <support_at_dbainfopower.com>
Date: Wed, 11 Feb 2004 12:01:14 -0800
Message-ID: <qbKdnUXw1qEOFbfdRVn-hQ@comcast.com>

Hello Bob,

in 10g you should be able to use regular expressions. In 9i "OR" is the option.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Bob" <no_at_mail.com> wrote in message
news:sBuWb.531553$_x2.1127068_at_zonnet-reader-1...
> 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
Received on Wed Feb 11 2004 - 14:01:14 CST