try this

select substr(mdn,-4) from ....

It will give the last four digits