|
|
Archives of the TeradataForum
Message Posted: Mon, 01 Dec 2003 @ 14:36:17 GMT
Subj: | | Re: Inconsistent behaviour of 'Coalesce' function in VB application |
|
From: | | Victor Sokovin |
Jim,
On Mon, 1 Dec 2003 07:45:13 -0500, Jim Downey wrote:
| Why would you do the union all. Wouldn't the following work? The advantage would be one pass of the table. | |
The originator of this thread had tried the 'case' construction and reported that it did not work. This seems to be 'consistent' as
'coalesce' is only a shortcut for the 'case'. 'Union' seems to be the only alternative left, alas.
Regards,
Victor
| |