Here is a way - but this will fail if the name happens to be "John Ho". Even that can be fixed, but then there will be other cases, for example, "John Ho Jr".
SELECT
CASE
WHEN ao.officer_name LIKE '% [a-zA-Z][a-zA-Z]' THEN RIGHT(ao.officer_name, 2)
ELSE ''
END
If the code is of a specific pattern then you can add a condition in the above query
CASE WHEN ao.officer_name LIKE '% __' and RIGHT(ao.officer_name, 2) in ('pattern1','pattern2','pattern3',...,'patternN') Then RIGHT(ao.officer_name, 2) ELSE NULL END
How to get the last two letters only from string?
Posted - 03/04/2013 : 09:07:47
