select char(count(*)) from table;

SELECT id, CAST(salary AS DOUBLE), years
     FROM staff
     WHERE dept = deptnumber;

설명]
cast 함수를 사용하기도함.