SQL SERVER FUNCTION CONCAT CONCATENATE

SQL SERVER FUNCTION CONCAT CONCATENATE

--hi viwers, we are going to look at the concatenate function in SQL SERVER 2012 using SSMS

--we are going to append the first name in the customer table to the last name in the customer table

--let us start

SELECT CONCAT(C.FirstName,' ',C.LastName)
FROM DBO.DimCustomer AS C;

--notice that I placed a space in between first name and last name using inverted commas.

--that is it.