[thelist] [SQL] Case vs Decode

Thanks,

Just what I was looking (and not finding) for.

Mark



> rudy <r937 at interlog.comrote:
>
> > Just as a matter of interest - anyone know of any articles / have
> any
> comments on
> > when and where it is better to use a CASE statement, as opposed to
> DECODE?
>
> oh, man, ain't it great when i can find good examples via google
> faster than
> i could write something similar myself --
>
> "DECODE is a bastardized and non-standard version of CASE statement"
> ml
>
> "The CASE expression supports the use of SELECT statements for
> performing
> Boolean tests, which the DECODE statement does not allow."
> http://www.schemamania.org/jkl/booksonline/SQLBOL70/html/2_005_37.htm
>
>
> it would not surprise me to learn that DECODE goes quite far back in
> terms
> of when it was first available in the oracle sql language, whereas
> CASE is
> probably a more recent addition
>
> in any case, i'd use CASE, in, um, all cases ...
>
> rudy
>
> --
> * * 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 !
> http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_1037
> 3042.ht


--
ICQ: 3094740
mark.m at optushome.com.au