Archives of the TeradataForum

Message Posted: Fri, 12 Dec 2003 @ 20:07:06 GMT

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

Rick Davis wrote:

You can specify a format with leading zeroes for output but this will be used only by BTEQ:

select 25 (format '9999');

If you want Queryman/ODBC to use the format you must cast it to a char:

select 25 (format '9999', char(4));

Dieter

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