Archives of the TeradataForum

Message Posted: Fri, 03 Sep 2004 @ 15:52:35 GMT

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

Hi

In order to get queryman to display things in a different format, you need to cast it as a char column.

     SELECT 10.00 (FORMAT '$$999.99') (char(10))

will return $010.00

Hope this helps

Frank

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