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 ] )  

Examples

Code:

IN -> SqlServer_01.sql
SELECT CONCAT('Ray',' ','of',' ','Light') AS TITLE;

Output:

       TITLE|      
------------+
Ray of Light|   

Last updated