A bit expensive, but the following works:

declare @string varchar (100)

set @string = 'x:\folder1\folder2\folder3\test.txt'

select @string

select @string,reverse(right(reverse(@string), len(@string) - charindex('\',reverse(@string),1) + 1));