Archives of the TeradataForum

Message Posted: Mon, 28 Apr 2003 @ 15:58:57 GMT

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

This SQL statement should help:

SELECT
( CASE
WHEN COL1 IS NULL
THEN    '   '
ELSE
     COL1
END ),
COL2 FROM YOURTABLE;

Regards,

Naresh

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