STRING function [String]

Concatenates one or more strings into one large string.

Syntax
STRING( string-expression [, ... ])
Parameters
  • string-expression   The string to be evaluated.

    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.

Returns

LONG VARCHAR

LONG NVARCHAR

LONG BINARY

Remarks

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.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example

The following statement returns the value testing123.

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