String - Function Padding (lpad, rpad)
Table of Contents
1 - About
This function string add on the left or on the right a string pattern.
2 - Articles Related
3 - Database
3.1 - SQL Server
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