Search For

LPad - Left padding

Flag Hide Line Nos
Flagging a Snippet, takes the snippet to Moderator Attention;

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
Vote! You feel this code is working like charm ? Go a head Login and Press up arrow.
Didn't work ?, press down arrow and let us know the error in comments