something like

INDEX ON yourfield CANDIDATE FOR !EMPTY(yourfield)

?

> I have field which can be empty else it must be unique. Can I create such a index which will throw an error.

>

> Ajoy Khaund

>

>

--

Jean MAURICE

Grenoble - France - Europe

www.atoutfox.org

www.aedtf.org