جدا کردن بخشی از متن از اخرین "\" در sql server

DECLARE @FilePath VARCHAR(50)
DECLARE @FindChar VARCHAR(1)
set @FilePath= 'My\Super\Long\String\With\Long\Words'
set @FindChar= '\'
-- Shows text before last slash
SELECT LEFT(@FilePath, LEN(@FilePath) - CHARINDEX(@FindChar,REVERSE(@FilePath))) AS Before
-- Shows text after last slash
SELECT RIGHT(@FilePath, CHARINDEX(@FindChar,REVERSE(@FilePath))-1) AS After
-- Shows the position of the last slash
SELECT LEN(@FilePath) - CHARINDEX(@FindChar,REVERSE(@FilePath)) AS LastOccuredAt