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?
>>
>>no.
>>
>>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)


HTH

--
Milan Babuskov
http://fbexport.sourceforge.net