Unique and nulls ?

[Ruslan Zasukhin]

On 4/10/07 11:43 AM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hi List,
> 
> is it possible to combine for a given field the nullable and unique
> properties in such a way that the null values are excluded from the
> unique test ?
> 
> Case: field mailaddress
> This field should be unique but I do not always have a mailaddress so
> it needs to accept null values. These null values should be excluded
> from the unique test.

YES,

UNIQUE field still can be NULLable.




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]