Home Forums SQL Server 2008 T-SQL (SS2K8) Remove characters after last slash in string RE: Remove characters after last slash in string
Lynn Pettis
SSC Guru
Points: 442467
More actions
March 25, 2013 at 12:40 am
#1600182
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));