select substring(empid,1,LEN(empid)/2),substring(empid,(LEN(empid)/2) 1 ,LEN(empid)) from tab1