substring

[Hammad Nasim]

Hi
I need some help with substring. How can I extract last four digit of a
field say card_no (this field has in some instance 10 digits and for some
value has 20 digits).

Thanks