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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
