Subject Re: [firebird-support] avoiding duplicates
Author Ivan Prenosil
> Alter Table Company
> Add Constraint CK_NAME Check (Not Exists (Select Distinct Upper(Name)
> from Company));

This constraint will allow inserting one row (or perhaps few more since it is not multiuser safe),
regardless company name :-)

Ivan