String - Function Padding (lpad, rpad)

This function string add on the left or on the right a string pattern.

This function does not exist and you can use this trick.

select right('0'+ week , 2) from DIM_WEEK
GO

where the function:

• add the pattern '0' on the left
• return the right part of the text