index column Unique or empty

Author: Ajoy Khaund

Posted: 2008-11-11 at 01:43:37

Hi

I have field which can be empty else it must be unique. Can I create =

such a index which will throw an error.

TIA

Ajoy Khaund

Neamati Road

Near Bhogdoi Bridge

Jorhat 785001-21

Assam, India

Tel: 91-376-2351288

Cell: 91-94350-92287

Mail: akhaund@hotmail.com

Mail: akhaund@gmail.com

"Walking on water and developing software from a specification are easy =

if

both are frozen."

- Edward V. Berard, "Life-Cycle Approaches"

--- StripMime Report -- processed MIME parts ---

multipart/alternative

text/plain (text body -- kept)

text/html

---

©2008 Ajoy Khaund