Joining values in Sql Server in multiple ways.

Posted by vishalneeraj-24503 under Sql Server category on 10/31/2014 | Points: 40 | Views : 1264

1st way :- Using + Sign

Select 'Dot' + ' ' + 'Net' + ' ' + 'Funda' + ' ' + '.com' as 'Full Site Name';

2nd way :- Using Concat in-build Function

Select Concat('Dot',' ','Net', ' ','Funda','.com') as 'Full Site Name';

3rd way :- Using Space in-build function

Select 'Dot' + Space(1) + 'Net' + Space(1) + 'Funda' + Space(1) + '.com' as 'Full Site Name';

Here,space(1) means one single space.

Output:-
Dot Net Funda .com

Bookmark It

Latest Code Snipptes