CONCAT
Description
Makes a concatenation of string values with others. (CONCAT in Transact-SQL).
Sample Source Pattern
Syntax
CONCAT ( string_value1, string_value2 [, string_valueN ] ) Snowflake SQL complete documentation
CONCAT( <expr1> [ , <exprN> ... ] )
<expr1> || <expr2> [ || <exprN> ... ]JavaScript complete documentation
String.concat( expression1, ..., expressionN )Examples
Code:
SELECT CONCAT('Ray',' ','of',' ','Light') AS TITLE;Output:
TITLE|
------------+
Ray of Light| Code:
SELECT
CONCAT('Ray',' ','of',' ','Light') AS TITLE;Output:
TITLE|
------------+
Ray of Light| Code:
CREATE OR REPLACE FUNCTION concatenate_strs(strings array)
RETURNS string
LANGUAGE JAVASCRIPT
AS
$$
var result = ""
STRINGS.forEach(element => result = result.concat(element));
return result;
$$;
SELECT concatenate_strs(array_construct('Ray',' ','of',' ','Light')) TITLE;Output:
TITLE|
------------+
Ray of Light| Last updated