String - Function Padding (lpad, rpad)

Data System Architecture

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





Recommended Pages
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