0

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

Tushar
  • 3,527
  • 9
  • 27
  • 49
Akshay
  • 1
  • 1

0 Answers0