At 01/22/2002 12:05 PM (Tuesday), Jason Frey wrote:

>I only need case insensitivity for one
>operation (A list box containing a list of records to be selected, ordered
>by last name.. Technically this is user entry error, however how many users
>are going to do everything the right way every time :)).
>Any ideas?

Do it on the client: Query the records from the database, copy the values
to a sorted TStringList which has a case-insensitive Compare method, assign
the string list to the items in the listbox. Use the string list's Objects
property to associate each string with a record from the original query so
you can discover which record was selected.