Get File Name From File Path In SQL

DECLARE @FILEPATH VARCHAR(1000)

SET @FILEPATH = 'E:\p\New\Folder\FolderSub\My.FileExtension'

SELECT RIGHT(@FILEPATH, Charindex('\', Reverse(@FILEPATH)) - 1)