LPAD

Purpose

This function returns a string of length n, which is string, filled from the left with expression padding.

Syntax

lpad::=

Usage Notes

  • If the variable padding is not specified, spaces are used.
  • If the string is longer than n characters, then the first n characters of the string are returned.
  • Even if n is greater than 2,000,000, the result string is truncated to 2,000,000 characters.
  • For filling a string from the right, please refer to function RPAD.

Example

SELECT LPAD('abc',5,'X');