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.