Archives of the TeradataForum
Message Posted: Fri, 06 Aug 2004 @ 18:16:38 GMT
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')
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|