Archives of the TeradataForum

Message Posted: Fri, 06 Aug 2004 @ 18:16:38 GMT

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

Hi all,

I am still a newbie here - I'm looking for a string function like lpad.

     lpad(string text, length  integer [, fill  text])

text Fill up the string to length length by prepending the characters fill (a space by default). If the string is already longer than length then it is truncated (on the right).

     Select  lpad('hi', 5, 'xy')

Result: xyxhi

What is the best way to get this functionality in Teradata?

My exact problem is to convert an integer to a string with zero padding for a given length.

Thank You,

--Don

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