Yes, I know, sorry for the confusion. I meant that both Oracle and MSSQL support COALESCE as it is the ANSI-92 standard. The T-SQL version (which other db's do not necessarily support) is IsNull On Mon, Mar 15, 2010 at 11:11 AM, Jason Handby <jason.handby at corestar.co.uk> wrote: >> COALESCE is the standard SQL version. The MSSQL (T-SQL) version is >> IsNull(column,default) > > T-SQL has COALESCE. > > http://msdn.microsoft.com/en-us/library/ms190349.aspx > > > > Jason > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! >