We can use Concat built-in function to concat 2 string.Select Concat('Ritesh', ' ','Kumar') As Name;

Concat

Concat()

Concat()

Concat()

Concat()

Using concat function Like Concat("first string ","she string")

Concat("first_string","second_string")

Concat built in function is not working in sql 2008 solved : SELECT { fn concat ('Navdeep', 'Singh') }

select name+','+address+','+sex+','+mobileNo from Tbl_Person