Fetch filenames from filepath in column

Fetch Filenames from Filepath stored in column SQL

SELECT REVERSE(SUBSTRING(REVERSE(filepath), 0, CHARINDEX('\', REVERSE(filepath), 1))) from xpatientnotes