Coalesce is a WAY cooler name. Those guys at MS must have been smoking crack!
____________________________________ Andy Matthews Senior Coldfusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com -----Original Message----- From: Jacob Munson [mailto:[EMAIL PROTECTED] Sent: Monday, January 08, 2007 7:41 PM To: CF-Talk Subject: Re: PostgreSQL vs. MSSQL > > > - non-standard sql > > Indeed. This is true in some rare cases (like case sensitivity) > however, it seems all databases take some liberties in regards to this. I agree, I think every database has some non-standard SQL. An example in MS SQL is the isNull() function, which is functionally equivalent to the ANSI standard coalesce(). Why did MS make their own? Who knows, maybe because they liked their name better? Back to your regularly scheduled programming. :) -- My Sites: http://www.techfeed.net/blog/ http://www.cfquickdocs.com/ http://cfformprotect.riaforge.org/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266048 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4