>>> Is it possibe to set a field to unique but case insensitive ?
>> Yes. With an ODS 11 database, you can create an expression-based index
>> like that. E.g.:
>>
>> create unique index i_t1_vc2 on t1 computed by (upper(vc2));
>>
>> where t1 is the table and vc2 the case insensitive unique field.
>
> However, an index is not the same as a constraint :-)

Right, but as we have seen in the past, people usually don't care if it
is a constraint or an index. ;-)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/