Hi Luciano,

"Luciano RM" wrote:

> Please, is there any way to do a > WHERE LIKE 'text%' < case
> insensitive without using UPPER?
>
> I can not else use CONTAINING and can not change the collate.

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