Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to create a filename parsing function:

USE AdventureWorks2008;

GO

CREATE FUNCTION fnParseFileName

               (@PathName VARCHAR(128))

RETURNS VARCHAR(128)

AS

  BEGIN

    RETURN

      (SELECT reverse(left(reverse(@PathName),

              charindex('\',reverse(@PathName),1) - 1)))

  END

GO

SELECT dbo.fnParseFileName('\\QAServer\d$\export\data\Sales20061001.csv')

GO

-- Sales20061001.csv