Search For

LPad - Left padding

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


1
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
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

Comments