SrJoven
0
Q:

sql right characters


  SELECT RIGHT('SQL Tutorial', 3) AS ExtractString; 
2
-- For Oracle only

-- syntax 
SUBSTR(<main-string>,-<number-of-characters>)

-- example 
SUBSTR('Useless stuff',-9) -- OUTPUT: ess stuff

-- practical example
SELECT SUBSTR('Useless stuff',-9)
FROM DUAL;
1

New to Communities?

Join the community