SAP PAPM

SAP HANA SQL LPAD Function

LPAD is used to pad a string. You need to specify the length of string, this number should be an integer. You need as well to specify the string of characters to use for padding.

Example:

Starting string of characters: END

LPAD formula: LPAD (‘END’, 15, ‘12345’)

RESULT: The LPAD formula returns the following string ‘123451234512END’

 

Related Articles

Check Also
Close
Back to top button