Archives of the TeradataForum
Message Posted: Wed, 19 Mar 2008 @ 20:25:36 GMT
<-- Anonymously Posted: Wed, 19 Mar 2008 13:31 -->
Thanks very much - nesting The NullIF in my COALESCE does what I want.
COALESCE(NULLIF(COLA, ' '), '*' ) AS COLA
this also worked:
COALESCE(NULLIF(COLA, ''), '*' ) AS COLA
Incidentally, we have an ASCII function that returns a 0 for this value, meaning Null?
When I use the Characters function, it returns 1.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|