-- 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;
DECLARE @strvalue varchar(20) = 'SDADH/SDKDS/SD/UIO-123/WEA/456' SELECT REVERSE(SUBSTRING(REVERSE(@strvalue),0,CHARINDEX ('/',REVERSE(@strvalue))))