SQL Eval Function Path_GetFileName

Path_GetFileName returns the file name and extension of the specified path string.

Path_GetFileName (
	@path NVARCHAR (4000)
	)
RETURNS NVARCHAR (4000)

Parameters

  • path: The path string from which to obtain the file name and extension.

Returns

The characters after the last directory character in path. If the last character of path is a directory or volume separator character, this method returns empty string. If path is null, this method returns null.

Example

SELECT SQLNET::Path_GetFileName('C:\Temp\MyTest.txt')

Contents