Hey Will... I've experienced the same thing and would be curious to know as well... I've just chalked it up to just being a pure syntax thing... nothing more than that's just the way it is in SQL server... let's see if anybody can clarify
Tim -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 09, 2006 5:27 AM To: CF-Talk Subject: IS NULL VS = NULL SQL Server - I had a situation where I needed to make sure a field was NULL. So I used WHERE the field = NULL. It didn't return any records, but it should've. So I changed it to WHERE thefield IS NULL, and it works fine. Why is this? What's the difference between = NULL and IS NULL? Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231721 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