[thelist] can i merge columns in an Oracle query?

Judah McAuley judah at wiredotter.com
Mon Mar 15 13:14:11 CDT 2010


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 !
>


More information about the thelist mailing list