SQL Server CONCAT Function

Example

Add two strings together:

SELECT CONCAT('iampsp', '.com');

Definition and Usage

The CONCAT() function adds two or more strings together.

 

Syntax

CONCAT(string1, string2, ...., string_n)

Continue reading SQL Server CONCAT Function