reading from right to left from string find first special characters in sql
-- 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;
4.11
9
DECLARE @strvalue varchar(20) = 'SDADH/SDKDS/SD/UIO-123/WEA/456'
SELECT REVERSE(SUBSTRING(REVERSE(@strvalue),0,CHARINDEX ('/',REVERSE(@strvalue))))
Thank you!
9
0
Are there any code examples left?
New code examples in category SQL