SQL SERVER – CONCAT function and NULL values
CONCAT is the new T-SQL function introduced in SQL Server 2012. It is used to concatenate the values. It accepts many parameter values seperated by comma. All parameter values are concatenated to a single string. A simple example is SELECT CONCAT('SQL Server',' 2012') which results to SQL Server 2012 The…
Read More


