Concatenates one or more strings into one large string.
Parameter |
Description |
---|---|
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 (''). |
LONG VARCHAR
LONG NVARCHAR
LONG BINARY
The result data type is a LONG VARCHAR. If you use STRING in a SELECT INTO statement, you must have an Unstructured Data Analytics Option license or use CAST and set STRING to the correct data type and size.
The following statement returns the value testing123:
SELECT STRING( 'testing', NULL, 123 ) FROM iq_dummy