Prasan,
How about you muck with the value the user gives you before the search?
if:
$VendorName$ = "AdFtt"
Then
you fix it to be: "[Aa][Dd][Ff][Tt][Tt]"
And your resulting LIKE operation should be "case insensitive".
(('Vendor Name' LIKE ( "[Aa][Dd][Ff][Tt][Tt]" + "%" ))
An Active link guide that keeps track of which character it is
processing, and creates a "[<UPPER($LETTER$)><LOWER($LETTER)>]" (set
of 4 characters) for every character it finds in the field should get
the job done.
[ I guess I am just in a loop'ing mode today. I keep answering
questions with the same basic idea. :) ]
Or you could go for ARS FTS licenses. :)
--
Carey Matthew Black
Remedy Skilled Professional (RSP)
ARS = Action Request System(Remedy)
Solution = People + Process + Tools
Fast, Accurate, Cheap.... Pick two.
Never ascribe to malice, that which can be explained by incompetence.
On 7/24/06, Prasan Katti <[EMAIL PROTECTED]> wrote:
**
Hi List,
We have developed a customized workflow application and we are having
problems with one of the set field condtions.
We have a Vendor Form master data which basically consists of the Vendor
name and Vendor Address.
I have the same two fields in another form which is used to create the
tickets, the users type in the first few letters of the vendor name and
click on a search button.
If there are multiple requests matching the query, we display a list and if
no requests match we show an error.
The problem we are facing is that the following query in the set field
action of the button click is case sensitive
('Vendor Name' LIKE ( $VendorName$ + "%" ))
The Vendor Name data in the master form is a mixture of Capital and Small
case letters, and should match with any data the users type.
Is it possible to implement a case insensitive search in this scenario??
We have ruled out using a direct SQL because for multiple request match, the
list diplays the header as Column1 and Column2 instead of "Vendor Name" and
"Vendor Address".
Any help is greatly appreciated.
Thanks,
Prasan
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
