Unanswered: How to get the last number of an integer number?
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