Skip to main content

Description

Uses printf-style template to formats a set of values using the native Java formatter library.

Syntax

SPRINTF(format_expression[, val1] […, valN])

Arguments

format_expression - string expression that evaluates to a printf-style template val1 … valN - Values to place in the template. Their data type must match the formatting argument category. Note that datetime values are not supported - use ToString to format a datetime expression.

Examples

SPRINTF('%d is a %s',50,'number') returns ‘50 is a number’.

Return value datatype

String

Impact of null value

If any input is null, returns null.
Last modified on April 20, 2026