Archives of the TeradataForum

Message Posted: Fri, 24 May 2002 @ 15:38:29 GMT

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

Ooops, off by one 0 but you get the point.

corrected: select substr('0000000000000000000', =
char_length(emplyee_nbr)) || emplyee_nbr

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