I have a Database-field (CHAR60) that contains text with upper and lower case letters. In my application, the user can search for entries in the DB table using this field, which leads to an SQL statement like this:
SELECT * FROM table WHERE field LIKE pattern INTO...
If I search for "abc", i won't find entries with "aBc". Can I do a case-insensitive search with SELECT and LIKE?
What is the domain(CHAR60) for the field that you are searching for?
The domain has an attribute called <i>Lowercase</i>, and it is my understanding that so long as this is checked, the data will be stored in the database exactly like it was entered on the screen (case-sensitive).
If thst is the case with your domain, then I guess you would have to make do with something like:
TRANSLATE : TABLE-FIELD TO UPPERCASE,
PATTERN TO UPPERCASE.
IF TABLE-FIELD CS PATTERN.
* Do your processing here...or fill the internal table
I know this code has been a bit crude, but this is the essence.