Pipe delimited string

How to read pipe delimited string without using a function

Solution

You have to read a pipe delimited string from left side as you want only the last delimited part.

You can use this:-

SELECT 
    REVERSE(SUBSTRING(REVERSE(LEFT(content, LEN(content)-1)), 0,CHARINDEX('|',REVERSE(left(content, LEN(content)-1)),0)))
FROM #SomeTable
 

More Questions