I have a table named T_INFO, and there is a column named CODE whose type is INTEGER. Now I wanna get the last number of every value of this column. I try to use left(cast(CODE as char(10)),1),but as the length of the number is not a fixed number,so using char(10) may not get exact string I want. How should I write the sql? Thank you

I thought too much about this,what I should do is just mod(code,10)