Are you saying that in Firebird, unlike (say) Sybase and Microsoft
SQL Servers, there is not an option when you set up a database for
everything to be case-insensitive, so that "equals" matching is
always case insensitive? That could be a problem for some users, such
as myself.

--- In firebird-support@yahoogroups.com, "Myles Wakeham" <myles@t...>
wrote:

> I'm trying to determine the general conventions that developers use

for

> searching Firebird (or any other SQL database) relating to

upper/lower case

> searching.
>
> 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
>
> ===========================
> Myles Wakeham
> Director of Engineering
> Tech Solutions Inc.
> Scottsdale, Arizona USA
> Phone (480) 451-7440
> Web: www.techsol.org