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
|