> > > - 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:266020 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
