SQL Eval Function Path_GetFileNameWithoutExtension

Path_GetFileNameWithoutExtension returns the file name and extension of the specified path string without the extension.

Path_GetFileNameWithoutExtension (
	@path NVARCHAR (4000)
	)
RETURNS NVARCHAR (4000)

Parameters

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

Returns

The path string minus the last period (.) and all characters following it.

Example

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

Contents