SQL · String functions

format()

Builds a string with placeholders. SQLite 3.38+ and PostgreSQL.

sqlRunnable example sql course

Syntax

format(template, …values)

Example

Open in the lab

SELECT format('%s has %d lessons', 'CSS', 16) AS summary;

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