Dear Friends,
 
Is there a way to specify wildcard inside values of an in clause. I want to
be able to do this:
 
    select id, name from tableName where name in ('a%', 'b%', 'c%');
 
instead of doing 
 
    select id, name from tableName where name like 'a%' or name like 'b%' or
name like 'c%';
 
Thanks,
Ravi.

Reply via email to