Archives of the TeradataForum
Message Posted: Mon, 03 Jun 2002 @ 14:08:48 GMT
Using COALESCE is like using a CASE expression, so you need to use parenthesis, just like you need them in the following example :
explain select (case when 1=1 then '1' else '0' end) || 'ffo'
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|