LPAD Function Examples | VantageCloud Lake - LPAD Function Examples - Teradata Vantage

SELECT LPAD('building', 11, 'yz');

Result:

'yzybuilding'

SELECT LPAD('building', 5, 'yz');

Result:

'build'

SELECT LPAD('building', 11);

Result:

'   building'

The space character is used by default to pad the source string.

SELECT LPAD('building', 5, 'yz');

Result:

'build'

SELECT LPAD('building', 11);

Result:

'   building'

The space character is used by default to pad the source string.