Hi Peter,

I can not use this options because I´m hadling a code that
uses Firebird and SQL-SERVER, so we insert the SQL statments
by .SQL.Add property.

We have some tokens to handle the DML´s statments diferences,
but this one is particulary complicated.

Best regards.

Luciano RM

Quoting "peter_jacobi.rm" <peter_jacobi@...>:

> Hi Luciano,
>
> Essentially,
>
> - using UPPER
> - giving a COLLATE
> or
> - using CONTAINING
>
> are the options. So, to get a more useful answer, I suggest
> you give some more background why none of these three
> options should be used.
>
> Regards,
> Peter Jacobi