Joining values in Sql Server in multiple ways.

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 340
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

Comments or Responses

Login to post response