String - Function Padding (lpad, rpad)

Data System Architecture


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


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

Discover More
Data System Architecture
Text - String

A string is a finite sequence of characters with the same coding representation (ie character set). As a sequence is, a string is also characterized as an abstract data structure case...

Share this page:
Follow us:
Task Runner