How can I do case insensitive searches in Uniface?
This question usually comes up with regard to mixed case names (or other data) being stored in a database, and a need to search for it without knowing precisely how the case of the data was entered. Even if the data were entered with reasonable consistency, some names use different capitalization. Both of the following might be correct entries: NAME DePrez, Michael Deprez, Michael Consider a Uniface form that allows a user to enter the first few letters. The resulting profile might produce Uniface driver calls to build a SQL statement such as: SELECT .. FROM CUSTOMERS WHERE NAME LIKE “Dep%” Most DBMS’s will only return the second of the two names above. What is needed is a way to return a selection regardless of the case of either the selection string or the data in the database. There is no simple solution to this, and performance plays a huge role in whether a given solution may be acceptable. The solutions generally fall into one of the following groups: • Change the data in the dat
