Archives of the TeradataForum
Message Posted: Fri, 11 Apr 2008 @ 16:20:20 GMT
I had the same thought and since David expressed my same concern so well, what if you did something like this:
case when col.id <>0.0 then cast(col.id as float) else 'failure'.
This will display the word failure whenever the col.id value is = 0 (zero). Of course you could use any word, even 'zero' to express the fact that your sql to make it a float.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|