fn_FilenameFromFullPath.sql

/*
  fn_FilenameFromFullPath.sql (c) 2017 Jarrett Meyer
 
  Description: 
    Extracts a filename from a full path. Files may have spaces.
 
  Examples:
     dbo.fn_FilenameFromFullPath('file.txt')                   -> 'file.txt'
     dbo.fn_FilenameFromFullPath('C:\file.txt')                -> 'file.txt'
     dbo.fn_FilenameFromFullPath('C:\temp\examples\file.txt')  -> 'file.txt'
*/
IF OBJECT_ID('dbo.fn_FilenameFromFullPath') IS NULL
	EXEC ('CREATE FUNCTION dbo.fn_FilenameFromFullPath () RETURNS INT AS BEGIN RETURN 0; END');
GO

ALTER FUNCTION [dbo].[fn_FilenameFromFullPath]
(
	@fullpath NVARCHAR(256)
)
RETURNS NVARCHAR(256)
AS
BEGIN
	DECLARE @dirSep NVARCHAR(1) = '\';
	DECLARE @filename NVARCHAR(256);

	IF CHARINDEX(@dirSep, @fullpath) > 0
		SET @filename = RIGHT(@fullpath, CHARINDEX(@dirSep, REVERSE(@fullpath)) - 1);
	ELSE
		SET @filename = @fullpath;

	RETURN @filename;
END
GO