The LPAD (left pad) function is used to pad an expression on the left with spaces (default) or a string expression. This functions accept three parameters

  1. Expression to pad
  2. Length
  3. Padding expression (optional)
Example :

Select Lpad(EmpNbr, 10, '0') 
From EmpMast
 
Result:
0000000260

Leave a Reply

Your email address will not be published.