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


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