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