> thanks for all the valuable clarification. However, the above seems > contradictory. After all, if more than one row can be NULL, then they > won't be UNIQUE! what gives?
SQL NULLs are weird. The expression NULL==NULL evaluates to NULL. It's and SQL thing, not particular to SQLite. __________________________________ Discover Yahoo! Have fun online with music videos, cool games, IM and more. Check it out! http://discover.yahoo.com/online.html