STRING( string-expression [, ... ] )

• LONG VARCHAR
• LONG NVARCHAR
• LONG BINARY

Numeric or date parameters are converted to strings before concatenation. The STRING function can also be used to convert any single expression to a string by supplying that expression as the only parameter.

If all parameters are NULL, STRING returns NULL. If any parameters are non-NULL, then any NULL parameters are treated as empty strings.

• String functions

The following statement returns the value testing123.

SELECT STRING( 'testing', NULL, 123 );