Archives of the TeradataForum
Message Posted: Wed, 19 Mar 2008 @ 22:13:13 GMT
<-- Anonymously Posted: Wed, 19 Mar 2008 17:12 -->
I appreciate the help - I think I'm all set.
Without going into great context, the process that got us to this point is the reason for the difference, not the source data.
The three fields I initially looked at are CHAR(1).
We have a function called ASCII that returned value 0, but CHARACTERS function returned value 1.
Using the NullIf allowed me to equate them.
select coalesce (Nullif(colA, ''), '*') from TableX minus select coalesce(colA , '*') from TableY
one thing I found surprising: all three below returned a *.
,COALESCE(Nullif(colA, ''), '*' ) AS colA ,COALESCE(Nullif(colA, ' '), '*' ) AS colA ,COALESCE(Nullif(colA, ' '), '*' ) as colA
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|