xp_sprintf system procedure

xp_sprintf(
format
, parm [, parm2 ... ]
)

format Use this CHAR(254) parameter to specify how to format the result string, using place holders (%s) for each parm argument. There can be up to fifty place holders in the format argument, and there should be the same number of place holders as parm arguments.
parm The input strings that are used in the result string. You can specify up to 50 of these CHAR(254) arguments.

Column name	Data type	Description
output_buffer	CHAR(254)	Returns a result string built from the format and parm arguments.

None

The following statements put the string Hello World! into the result variable.

CREATE VARIABLE result CHAR( 254 );
CALL xp_sprintf( result, '%s %s', 'Hello', 'World!' );