FORMAT(...)

All functions > STRING > FORMAT(...)

C-style string formatting: a VARCHAR template plus one scalar per placeholder.

Signatures

Returns: Formatted string

FORMAT_FN(format: VARCHAR, values: scalars…) → VARCHAR

Notes

• Variadic FORMAT(...) / PRINTF(...) bundles trailing arguments like variadic CONCAT_WS(sep, ...)
• NULL in a value position typically makes the whole result NULL; use COALESCE for sentinels

Availability

Available on DuckDB, Trino. Not available on Serving.

Related operators

• FORMAT(...)

Examples

FORMAT_FN(...)

SELECT
    -- Array form with one value
    f1 := FORMAT_FN('n=%s', ARRAY('7'))
;