Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

LPad - Left padding in Informatica

  1. Forget Code
  2. Informatica
  3. LPad - Left padding
The LPAD function adds a set of blanks (Empty Spaces) or characters to the beginning of a string, and makes the string to uniform Length

General Syntax
LPAD (first_string, length [, second_string])

When the second argument is omitted, Informatica Pads with Spaces.

Example : Pads Marks With 0's and the length of the string is always uniform 
LPAD (Marks, 3, '0')

MarksReturn Value
10010
100100
5005