SQL · String functions

lpad() / rpad()

Pads a string to a fixed width. PostgreSQL; use printf() in SQLite.

sqlRunnable example sql course

Syntax

lpad(text, length, fill)

Example

Open in the lab

SELECT printf('%5s', '7') AS padded;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.