How to take last four characters from a varchar?

Right should do:

select RIGHT('abcdeffff',4)

RIGHT ( character_expression , integer_expression )

SELECT RIGHT(column, 4) FROM ...

Also a list of other string functions.

SUBSTR(column, LENGTH(column) - 3, 4)

LENGTH returns length of string and SUBSTR returns 4 characters from "the position length - 4"