Contents Index STR function [String] STRTOUUID function [STRING]

ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

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.

Usage 

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.

Standards and compatibility 
Example 

The following statement returns the value testing123.

SELECT STRING( 'testing', NULL, 123 )

Contents Index STR function [String] STRTOUUID function [STRING]