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;