I'm guessing that it is just a syntax thing...somewhere in the SQL Server engine, it makes it easier for them to handle the comparison. Oddly, the update isn't like that...when you set a column to NULL, you use "col_name = NULL", not something like "col_name TO BE NULL"
On the subject, here is a pretty good article about why NULL should be avoided.... http://www.aspfaq.com/show.asp?id=2073 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231724 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
