I have a sql column Employee_Id , I want display all data of this column in two equaly devided column in one table
Prafull Goswami
select substring(empid,1,LEN(empid)/2),substring(empid,(LEN(empid)/2) 1 ,LEN(empid)) from tab1