String - Function Padding (lpad, rpad)

1 - About

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

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

where the function:

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

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap