The solution is here try this one.

Declare @Delimiter CHAR(1),@InputString VARCHAR(100)

SET @Delimiter = '|'

SET @InputString = '135721|OL512K12M00003716|11C49EE2ED'

SELECT REVERSE(SUBSTRING(REVERSE(@InputString),0,

CHARINDEX(@Delimiter,REVERSE(@InputString),1)))