I hit enter too early..
Also in Oracle you have the advantage of selecting what you want your escape
character to be..
For eg.
set escape '*'
Also, if I recall right, it could be a string something like
set escape 'oiqjdhdhgkjahiusrf'
If you want the escape characters to be a unique string that will not be
found in the string you want to use the escape characters in..
Joe
-----Original Message-----
From: Joe Martin D'Souza
Sent: Wednesday, May 02, 2012 2:15 PM
To: ARS List
Subject: Re: Using % in Run if on Display Only field
You can set escape in oracle using
set escape '\'
I have not tried using this with % or _ but I'm guessing that’s the purpose
of setting escape on..
Joe
-----Original Message-----
From: Guillaume Rheault
Sent: Wednesday, May 02, 2012 1:52 PM Newsgroups:
public.remedy.arsystem.general
To: [email protected]
Subject: Re: Using % in Run if on Display Only field
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"
