In oracle we used below query to display the last three characters of last_name.
SELECT SUBSTR(LAST_NAME,-3) FROM
Can someone help me how to perform in tetadata with outadding POSITION/INDEX?
You might need to add a case expression in case the last names is shorter then 3 characters....
In case CHARACTERS doesn't work, you can also use CHARACTER_LENGTH function to get the length of character field.
Here you go....
SELECT substr(LAST_NAME, character(LAST_NAME)-2) from EMPLOYEES;