In oracle the command would be
select substr([your column name],-2,2) from [your table name]
In MSSQL you would use substring instead of substr.
you could also use the Right function (select right(colname,2) from table if the database engine supports it.
*******Actually no, the Right function would not work in all cases – only if the column is varchar vs.
char or nchar********
I went back and tested with the substring function in MSSQL but it did not work. But the Right
function did work for varchar column. There is no Right function in oracle.