how to get last 4 digits of a particular field?

7723 Views

Hi to all,

here i have three fields,

f1 length 18 char,

f2 length 4 char,

f3 length 4 char,

now i want to take last 4 char of f1 to f2 and the same i have to pass to f3.

how to do this?

regards,

swami