How to get the file name from the path using Sql Server query?

SELECT FileName=reverse(left(reverse('\\C\user\sri\temp.txt'), Charindex('\',reverse('\\C\user\sri\temp.txt'), 1) - 1))