Concat two strings in SQL Server.

We can use Concat built-in function to concat 2 string.

Select Concat('Ritesh', ' ','Kumar') As Name;