Wildcard symbols are interpreted as wildcards only when used with the LIKE operator; otherwise, they are interpreted literally.
To use percent (%), underscore (_), or open bracket ([) characters as literal text in a LIKE operation: Microsoft SQL Server and Sybase—Enclose the character in brackets. For example, [_] matches only the _ character, not any single character. Informix—Insert a backslash before the character. For example, \% matches the % character, not any string of 0 or more characters. Oracle, you cannot use the LIKE operator to search for literal percent (%) or underscore (_) characters. Hope this helps Guillaume ________________________________________ From: Action Request System discussion list(ARSList) [[email protected]] on behalf of David Shepard [[email protected]] Sent: Thursday, April 19, 2012 2:19 PM To: [email protected] Subject: Using % in Run if on Display Only field Hello I want to restrict Wildcard searches on an Advanced Search field. The way i am doing this is with an Active Link and looking through a string by using the %. So if i want the AL to only run if the 'Name' field is entered I have tried the below RUN IF: 'Advanced Search' = "%Name%" 'Advanced Search' LIKE "%Name%" 'Advanced Search' = "%"+"Name"+%" The Active Link actually looks for the % in the 'Advanced Search' field. How do i get it to use the % instead of thinking it is text. Can this be done in the Run IF of an AL? Any help would be greatly appreciated. Thanks Dave _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
