J. Dex Others have addressed the situation where you are sorting the records. What I've seen is the situation where you are searching for a particular record. You end up with the situation with WHERE UPPER('my search string') = UPPER(column) As DBA, you can support this by creating a FBI (function-based index) on the column. The vendor must support this by including syntax such as the above in the SQL they create. If the vendor doesn't support this syntax, then your only alternative is to train your users to enter all data with a consistent case. Dennis Williams We are setting up an application (third-party out-of the-box type) and the > group that is setting it up would like to set it up so that when users > search for records the searches are NOT case sensitive. >