create table empdept
(deptid int , dept_name char (20) ,dept_off char (20) , dept_head int);
I want to convert deptid
to varchar
SELECT CONVERT(varchar(10), deptid) FROM empdept;
I did try this but not working
create table empdept
(deptid int , dept_name char (20) ,dept_off char (20) , dept_head int);
I want to convert deptid
to varchar
SELECT CONVERT(varchar(10), deptid) FROM empdept;
I did try this but not working