After reading the Derby document(s) I discovered that the UNIQUE constraint in Derby does not allow NULL values to be inserted into a cloumn with the constraint applied. So I was wondering if there was another way to achieve since the UNIQUE constraint was designed to do this
--------------------------------- Yahoo! Answers - Get better answers from someone who knows. Tryit now.