Kurt,

You can create a CHECK constraint on the column to validate the value.

>problem is that i can have multiple null values for that field in my file but only one true value (not null). Do you know another way to force an unique value in a record but allowing multiple null values ?