Yes you can have a contraint on a field that allows nulls. However, you cannot have nulls in a Primary constraint, and you can only have 1 in a Unique constraint.

Jon


>Hi all,
>
>is it possible to add a constraint on field that can cantain the null value. And if so can the file contain multiple records with the null value for that field with the constraint active ?
>
>thnx