Archives of the TeradataForum

Message Posted: Tue, 14 Dec 2004 @ 15:50:04 GMT

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

Use the "X" format specifier rather than "9"

     CAST((IDM.IDENTITY_ID (FORMAT 'X(09)')) as char(11))

But then justification!

Narayan

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