Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use like in 'IN CLAUSE' in sql

2960347May 29 2015 — edited May 29 2015

hi all ,

i want to write a select statement like below :

select distinct col1 from table

where coL1  IN ('B%','E%','G%')

The data for col1 is not static hence i need to pick values which starts with B,E,G.

Above sql is not working.

Kindly suggest fix/alternate for above issue.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 26 2015
Added on May 29 2015
6 comments
841 views