Get filename from an URL using Sql Server Function

I have written an User defined function, this may help you in getting the file name from an URL you pass as input.

[code]
CREATE FUNCTION dbo.GetFileNameFromURL
(
@Url VARCHAR(2000)
)
/* -- Comments --
Created By: Alwyn Duraisingh.M
Created On: 26th September 2010
Purpose: To get the filename from an URL
*/
RETURNS VARCHAR(255)
AS
BEGIN
DECLARE @FileName VARCHAR(255)
DECLARE @TempUrl VARCHAR(2000)
SET @TempUrl = REPLACE(@Url, '\', '/')
SET @TempUrl = REVERSE(@TempUrl)
SELECT @FileName = REVERSE(SUBSTRING(@TempUrl,1, CHARINDEX('/', @TempUrl) - 1))
RETURN @FileName
END
[/code]

you can call this function like;

SELECT dbo.GetFileNameFromURL('http://Folders/Adsingh/MyTextFile.txt')

Result:

MyTextFile.txt