Post
Ask Question

Prafull Goswami
I have a sql column Employee_Id , I want display all data of this column in two equaly devided column in one table
By Prafull Goswami in SQL Server on May 16 2017
  • Raghu Reddy
    Feb, 2019 10

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

    • 0


Most Popular Job Functions

View All

MOST LIKED QUESTIONS