Archives of the TeradataForum

Message Posted: Tue, 07 Sep 2004 @ 19:18:24 GMT

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

The easiest modification I can think of would be:

     select *
     from View1
     where (fiel1 IS NULL and NOT fiel2 IS NULL) OR (NOT fiel1 IS NULL and
     fiel2
     IS NULL)

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