DECLARE @filepath VARCHAR(1000)
SET @filepath = 'D:\ArchivedRecordings\From_DEFR4C7K1OP01\2004141507_2004141489_eed88bc8da41c8e458777675.xml '
SELECT REVERSE(LEFT(REVERSE(@filepath),CHARINDEX('\', REVERSE(@filepath), 1) - 1)) as filedetails
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day