Subject Re: [firebird-support] Re: Field to lower case
Author Milan Babuskov
a_broekhuis wrote:
>>>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?
> Because all my entered data is lower case.

You can do it like this:

where UPPER(field) = UPPER(:entered_data)


Milan Babuskov