STRING function [String]

Function

Concatenates one or more strings into one large string.

Syntax

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

Parameters

string-expression A string.

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 ('').

Example

The following statement returns the value testing123:

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

Usage

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.

Standards and compatibility