Hi Luciano,

--- Luciano RM <lcno@p...> wrote:

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

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