ASA SQL Reference
  System Procedures and Functions
    System extended stored procedures
      Other system extended stored procedures

xp_sprintf system procedure

Function 

Builds up a string from a format string and a set of input strings

Syntax 

[ variable = CALL ] xp_sprintf ( out-string,
format-string
[ input-string ] )

Permissions 

None

Description 

xp_sprintf builds up a string from a format string and a set of input strings. The format-string can contain up to fifty string placeholders (%s). These placeholders are filled in by the input-string arguments.

All arguments must be strings of less than 254 characters.

Example 

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

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