Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> sql: combine LIKE and IN
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
![]() |
![]() |