SELECT CONCAT('Ray',' ','of',' ','Light') AS TITLE;
Output:
TITLE|
------------+
Ray of Light|
Code:
OUT -> SqlServer_01.sql
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;
