Archives of the TeradataForum

Message Posted: Thu, 06 Nov 2003 @ 11:04:21 GMT

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

On second thought - if only one of the columns has data & the other is null you don't even need an indicator column. Coalesce, or checking for IS NULL would do.

Thanks,

Mirjam

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