Getting Middle Name 1 character with First and Last name and append it to get full name

Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 571
Suppose,First Name is Vishal,Middle Name is Kumar and Last Name is Neeraj,and we want to get Vishal.K.Neeraj,then we will use Left Sql Server in-built function as follows:-
Select First_Name + '.' + Left(Middle_Name,1) + '.' + Last_Name As AbbrvName 
From Employee_Master
Order By First_Name;

Comments or Responses

Login to post response