Re: help with decode

sybrandb_at_yahoo.com wrote:
> The syntax is
> <string expression>||<string expression>
>
> No comma's.

So the following are the same?

SELECT (DECODE(a1, 'b1', a2, 'b2')) from A

SELECT (DECODE(a1, 'b1 || a2, 'b2')) from A

Also if I use CHR(1) as follows what does it mean?

SELECT (DECODE(a1, 'b1 || CHR(1) || a2, 'b2')) from A

Thanks! Received on Wed Aug 03 2005 - 09:28:22 CDT