Hi James,

"Delmerico, James" wrote:

> I'm a MS SQL Server user and I am used to the default case-insensitive
> collation order. Is there a way to configure firebird to behave the

same

> way? I would like this to apply to indexes, constraints and be used

for the

> WHERE clause of a SQL statement.

As I guessed the break-even point has been reached, I just put
a little summary online:

http://www.jodelpeter.de/i18n/fbarch/case_insensitive_collations_in_firebird.html

For your requirements, the answers "Dave's" and "Proxy Columns"
seem to be the best fit.

Regards,
Peter Jacobi