Archives of the TeradataForum

Message Posted: Thu, 25 Nov 2004 @ 15:43:21 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

          case
           when field1 is null then -999.99
           else field1
          end

The COALESCE is implimented with a CASE statement. It could be used in the SELECT to turn a NULL into anything desired.

As an example:

     SELECT COALESCE(null_column,999999.99)
     from my_table;

See if this doesn't get you what you are looking for.

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>