Maybe if you SET the filed to the string 'NULL' but NULL has never been tested by '=' that I've seen. It's not a value. I doubt an update would change that. If it does, I'll be extremely ticked off as I'm changing tons of queries :-)
..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 9:20 AM 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:231727 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