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"
