Right Padding function is not readily available in Teradata but it can be acheived by computing the padding characters by substring function and adding them to the input string or column.

Sample Syntax:

SELECT 
SUBSTRING  'string' or column || ('characters to pad',1, length of characters to pad -LENGTH('string' or column))

Example:

Suppose we want to pad for a number 12 upto 5 characters(total) with zeros.

12 ------> 12***

SELECT 
'12' AS inputvalue, 
inputvalue || SUBSTRING('*****',1,5-LENGTH('12'))  AS after_padding

Remember, the number must be given as a string (should be in quotes)
Output:

inputvalue	after_padding
12	12***

Suppose we want to pad for a string 'aa' upto 5 characters with zeros.

aa ------> 000aa

SELECT 
'aa' AS inputvalue, 
 inputvalue || SUBSTRING('*****',1,5-LENGTH('aa'))  AS after_padding

Output:

inputvalue	after_padding
aa	aa***