Archives of the TeradataForum

Message Posted: Tue, 03 Jun 2008 @ 16:20:22 GMT

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

Hi,

Try this..

     Select
        CAST(mycol2 as varchar(20))
           From
           mytable;

I think you viewing data through sql assistant (or any ODBC tool). In some cases, ODBC tools overrides actual format.

BEST OF LUCK.

Best Regards,

Kapil Dev Sapra

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