Lynn Pettis (3/25/2013)
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));
Thank You