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
