Hi Peter,

I´ll check and try it.

Thanks.

Best regards.

Luciano RM

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

> Hi Luciano,
>
> Doesn't MS SQL have COLLATE? You can use MS SQL's default
> collation's name after collate, to make the COLLATE clause
> a no-op on MS SQL and rename the desired collation for
> Firebird to hear on this name.
>
> Or, and even better, because it allows an index to be used,
> put a collation into the column's DDL. Then at query time,
> no difference is seen.
>
> The LIKE has to re-formulated as BETWEEN (or straight comparison,
> as BETWEEN is only syntactic sugar).
>
> WHERE column BETWEEN 'text' AND 'textzzz'
>
> Regards,
> Peter Jacobi