Hi friends,
Iam doing an Search RFC which will search records based on the search parameters provided at the portal side.
One of the search parameter is a field with 40 character which holds the description(title) of the record.
With this search paramter iam facing case sensitive problem.
Example:
Values in Database Table: ( Can be in any case)
Record 1: Sensitive
Record 2: SENSITIVE
Record 3: SensTive
Record 4: sensitive
Record 5: sensTive
Input to RFC: sens*
Output: Getting only 4rth and 5th record but not all the records.
The same is the case with the remaining search parameters(Like user name..).
Is there any way of getting all the records when searching from the data base (with case insensitive).
Kindly let me know if there is any possibility.
Thanks in advance.
Regards,
Swarna Munukoti.