LPAD
Pads a string on the left to a specified length with a fill string.
Analyze Syntax
func.lpad(<str>, <len>, <pad>)
Analyze Examples
func.lpad('42', 5, '0')
┌─────────┐
│ '00042' │
└─────────┘
SQL Syntax
LPAD(<str>, <len>, <pad>)
SQL Examples
SELECT LPAD('42', 5, '0');
┌───────┐
│ 00042 │
└───────┘