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: