topic Re: Query on Pattern Option in Application Development and Automation Discussions

Query on Pattern Option

Former Member — Fri, 08 Aug 2008 05:15:07 GMT

Hi folks...........

Can any one tell me how to use pattern option in select query...??

Thanks & Regards........

Rajeev

former_member787646 — Fri, 08 Aug 2008 05:23:29 GMT

Using the wildcards "%" or "_".

*Eg: Select * from <table> where name LIKE 'M%'.*

*Eg: Select * from <table> where name LIKE '____'.*

Hope it helps.

Murthy