Hi,
you can try to use the CAST(expression AS data_type) or CONVERT (data_type[(length)], expression [, style])
functions.

ex:
select CAST(EMPNO AS char(2)) from EMP;
select CONVERT(char(2), EMPNO) from EMP;

regards.