You might have missed it.. **This is expected** =NULL will never work as NULL is not a value, it isn't anything really. - and therefore it cannot be equal to anything.
You always have to use IS NULL. -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: 09 February 2006 14:20 To: CF-Talk Subject: Re: IS NULL VS = NULL 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:231725 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
