Case Sensitivity

Access data is case insensitive; ex. “abc”, “AbC” and “Abc” all match a data field containing “ABC”. DB2 is case sensitive, such that only exact matches meet Query search criteria.
 
There are two ways to work around this problem. The most efficient way is to ensure criteria containing string constants match the intended data. This may require that the data is cleansed so that matches are consistent. For example, if one data field contains “Abc” and another “ABC”, and the data are logically equivalent, then reformat the data as follows:
update aTable set aField=”ABC” where aField = “Abc”.
The other method is to force a consistent case by using LCASE or UCASE on the data field, ex. select LCASE(aField) from aTable where aField="abc". This method will result in much slower query execution.
 
In either case, ensure that all user interfaces that perform inserts or updates to these problem fields are consistent in the way they format case-sensitive data.