Archives of the TeradataForum

Message Posted: Wed, 21 Nov 2007 @ 11:10:34 GMT

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

          > sel *
          > From   Test
          > Where
          >       Cast(Exit_Date As char) = ''
          >
          > Returns no value.

I can't reproduce your results. Perhaps they are specific to your release? Can you post the output of the following query?

     select *
     from dbc.dbcinfo;

Also, can you describe the output of the sightly modified query?

     sel *
     >From    Test
     Where Exit_Date is null

Regards,

Victor

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