SQL CONCAT Function

SQL CONCAT FUNCTION 1

The SQL CONCAT function is used to combine two or more strings and returns string. Unlike + Operator, the Concat function will convert Null values into an Empty string while displaying the result. The syntax of the SQL Server Concat function is SELECT CONCAT (String 1,String 2,..,String N) FROM [Source] This string concat function accepts N number of … Read more