aaahhh.. Thanks Fred. That works for me. Wasn't thinking of an alternative, just trying to make the other one work, :). Thanks.
On Thu, Jul 23, 2009 at 11:58 AM, Grooms, Frederick W < [email protected]> wrote: > ** > > Have you tried using an SQL menu instead of a Search menu? > > > > Fred > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *kiran kodali > *Sent:* Thursday, July 23, 2009 10:43 AM > *To:* [email protected] > *Subject:* Regular Expression match in ARS 7.1/Oracle 10G > > > > Hello All, > > > > I am trying to make this qualification work in a Search Menu, on ARS > 7.1/oracle 10G. > > > > 'Variable' LIKE "%[1-5]d[1-5]%" (Works in SQL Server and Sybase) ( > searching for strings containing, 1d1, 2d4, 5d5..etc.) > > > > Found that REGEXP_LIKE is the function for this kind of pattern matching in > Oracle 10G. > > > > I was able to make it work @ DB level using this .. REGEXP_LIKE (Variable, > '[1-5]d[1-5]'), but itz giving me error while using it as a Qualifcation in > search menu, seems REGEXP_LIKE is not supported in ARS. > > > > Plz let me know if someone has a idea on this. Thanks. > > -- > Regards, > Kiran Kodali > Ph: 940-231-8524 > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ -- Regards, Kiran Kodali Ph: 940-231-8524 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
