String - Function Padding (lpad, rpad)

About

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

Database

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

Powered by ComboStrap