Subject General conventions for Upper/Lower case searching
Author Myles Wakeham
I'm trying to determine the general conventions that developers use for
searching Firebird (or any other SQL database) relating to upper/lower case

The data in our search fields will be stored as mixed Upper Case/Lower case
textual data, but when we search for a matching value I'm not sure what the
best strategy is for this. One of our developers wanted to develop a UDF
for this, but I can't see why this is required.

If I want to seach a text field for 'Smith', and the values in the database
are referenced as 'SMITH', 'Smith', and 'smith' what is the best way to
handle this in an application?


Myles Wakeham
Director of Engineering
Tech Solutions Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440