CONCAT
Last updated
Last updated
Makes a concatenation of string values with others. (CONCAT in Transact-SQL).
CONCAT ( string_value1, string_value2 [, string_valueN ] )
Code:
SELECT CONCAT('Ray',' ','of',' ','Light') AS TITLE;
Output:
TITLE|
------------+
Ray of Light|