> > 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.

> > 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.

Changed it for now.

Strange thing is that the pdf docs on the site (the ones for
interbase) mention LOWER.

Thanks anyway.

Alexander