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
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.