Archives of the TeradataForum

Message Posted: Mon, 16 Jul 2012 @ 14:04:09 GMT

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

Hi Rajesh,

SQL should have OR condition, not AND condition to meet your requirement.

     Select * from emp
     Where dept is not null
     OR grade is not null
     OR  pone is not null
     OR cell is not null

Regards

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