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
