Munson, Jacob wrote: >> You might also consider investigating the use of the ISNULL() function > > FYI, IsNull() is an MS proprietary function, while Coalesce() is ANSI > SQL standard. It does the same thing, but using coalesce makes your > code more portable.
True, and I had never heard of "Coalesce", in all my years of doing database stuff inclucluding multiple versions of SQL Server, Oracle, Informix, DB2, MySQL, and Access over the last 10 years. Here's an interested relating blog entry I found... http://joseph.randomnetworks.com/archives/2006/03/15/nvl-isnull-ifnull-and-coalesce/ Question: "Why do folks even bother writing SQL that includes the use of nvl, isnull and ifnull?" Answer: Cuz we didn't know about it! ;) Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242497 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