Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> sql: combine LIKE and IN

sql: combine LIKE and IN

From: Bob <no_at_mail.com>
Date: Wed, 11 Feb 2004 19:41:24 GMT
Message-ID: <EzvWb.531835$_x2.1129380@zonnet-reader-1>


I am trying to improve the following:

select tbl.city
from tbl
where tbl.city like 'b%' or
tbl.city like 'd%' or
tbl.city like 'k%'

I have tried the following, but without success: where tbl.city like in ('b%', 'd%', 'k%')

Thanks,
Bob Received on Wed Feb 11 2004 - 13:41:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US