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.
- Like inside in clause Ravi Kumar.
- Re: Like inside in clause Thomas Spahni
- Re: Like inside in clause Brent Baisley