How to take last four characters from a varchar

Question

I m trying to take the last four characters only from a varchar field  All the rows are different lengths  What function should I be using to accomplish this

User · Answer

Use the RIGHT   function  http   msdn microsoft com en-us library ms177532 v sql 105  aspx  SELECT RIGHT   1234567890   4    -- returns  7890

User · Answer

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

User · Answer

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

User · Answer

You can select last characters with - WHERE SUBSTR  Hello world   -4

User · Answer

RIGHT   character expression   integer expression    SELECT RIGHT column  4  FROM       Also a list of other string functions

User · Answer

Right should do    select RIGHT  abcdeffff  4

User · Answer

tested solution on hackerrank      select distinct city  from station where substr lower city   length city   1  in   a    e    i    o    u   and substr lower city   1  1  in   a    e    i    o    u

[sql] How to take last four characters from a varchar?

Examples related to sql

Examples related to sql-server-2008

Examples related to tsql