mysql int2string

integer to string

select cast(grosspay as char(4)), employeenumber,datestart,dateend from payroll  where employeenumber='4';