How to use the SQL Server String Concat Function in SQL Server 2012

SQL Server 2012 includes a new Concat function that makes it easier to put strings, numbers, dates, and nulls together.

The old way was with ’+’ signs and cast or convert. Now you just use the SQL Server String Concat Function.

In this video I do a quick demonstration of the Concat Function.

I use the Chinook Sample Database and the following scripts:

select FirstName + ' ' + LastName + '-' + Company

from customer

select CONCAT(FirstName,' ',LastName,'-',Company)

from customer

See the original SQL Concat Function video.