STRING function [String]

Concatenates one or more strings into one large string.

STRING ( string-expression [ , … ] )

If only one argument is supplied, it is converted into a single expression. If more than one argument is supplied, they are concatenated into a single string.

A NULL is treated as an empty string ('').

The following statement returns the value testing123:

SELECT STRING( 'testing', NULL, 123 )
FROM iq_dummy

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

If all parameters are NULL, STRING returns NULL.