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?

no.

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.


Luc.