Archives of the TeradataForum

Message Posted: Wed, 16 Apr 2008 @ 16:52:18 GMT

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

I have no idea what you're really trying to accomplish, but the following query does what you described.

     abort 'Fail: Zero Value Not Allowed'
     from T1
     where 0.0 IN (select c1 from T1)
     ;select cast(c1 as float) from T1;

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