How to take last four characters from a varchar?

Question

Right should do:

select RIGHT('abcdeffff',4)

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

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

RIGHT ( character_expression , integer_expression )

SELECT RIGHT(column, 4) FROM ...

Also a list of other string functions.

Use the RIGHT() function: http://msdn.microsoft.com/en-us/library/ms177532(v=sql.105).aspx

SELECT RIGHT( '1234567890', 4 ); -- returns '7890'

For Oracle SQL, SUBSTR(column_name, -# of characters requested) will extract last three characters for a given query. e.g.

SELECT SUBSTR(description,-3) FROM student.course;

You can select last characters with -

WHERE SUBSTR('Hello world', -4)