Archives of the TeradataForum

Message Posted: Thu, 04 Dec 2003 @ 14:17:46 GMT

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

Anomy Anom wrote:

I write:

I think it will insert the blank to every row and is obvious from the below query after issuing the ALTER TABLE on t1.

sel char2hexint(abc),a,b,abc from t1;

        Char2HexInt(ABC)        a       b       ABC
        2020                    1       1
        2020                    1       11
        2020                    1       111

Thanks, Vivek.

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