Archives of the TeradataForum

Message Posted: Thu, 10 Dec 2004 @ 02:33:14 GMT

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

FORMAT (applied to the numeric field), followed by converting to character should do what you want:

     SELECT CAST(CAST(PAT_ENC_CSN_ID AS FORMAT 'Z(17)9') AS CHAR(18))

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