This is a good point, people use null way too much. Check out this article to see the problems of using null for blank values instead of known missing values: http://www.sqlservercentral.com/columnists/mcoles/fourrulesfornulls.asp
> -----Original Message----- > From: Ben Nadel [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 11, 2006 2:24 PM > > In that case you should probably modify your SQL so that it > cannot return a > NULL, but instead a default value: > > SELECT > id, > ISNULL( cost, 0 ) AS cost > FROM > product > > Now, you know that no matter what, your SQL will return a > valid number... I > would think that a NULL value would require chaning the code a bit? This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240285 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
