Please refer below code
SQL
Create Table #Users1
(
UniQueNumber Varchar(50),
FName varchar (50),
LName Varchar (50),
Number varchar(10),
CreateDate Datetime
)
INSERT INTO #Users1 Values ('44354','Kumar','Shruthi-hh','11111','05-25-2016 00:10:000')
INSERT INTO #Users1 Values ('44254','Shankar','Raj','22222','05-25-2016 01:18:000')
INSERT INTO #Users1 Values ('34154','Babu','Swamy-k','33333','05-25-2016 06:10:000')
INSERT INTO #Users1 Values ('35054','Mani','Kanta B','44444','06-25-2016 06:10:000')
SELECT (UniQueNumber + '-'
+ SUBSTRING(FName,1,1)
+ CASE WHEN PATINDEX('%-%',LName) > 0 THEN SUBSTRING(LName,0,PATINDEX('%-%',LName))
WHEN PATINDEX('%[ ]%',LName) > 0 THEN SUBSTRING(LName,0,PATINDEX('%[ ]%',LName))
ELSE LName
END) as UniQueNumber
,FName
,LName
,Number
,CreateDate
FROM #Users1
DROP TABLE #Users1
