Subject Re: [firebird-support] Field to lower case
Author Lucas Franzen
a_broekhuis schrieb:

> Hi,
> I need to do a case insensitive query. Is there some way to do this?
> I know I can use UPPER to make a field return its data in upper case,
> but is there also something for LOWER?


If there's already an UPPER what do you need a LOWER for?

> The data that is entered by the
> user is for the query is lowercase.

Use a function (like AnsiUpperCase in Delphi) to convert it to capital
letters before.