SQL Eval Function Path_HasExtension

Path_HasExtension determines whether a path includes a file name extension.

Path_HasExtension (
	@path NVARCHAR (4000)
	)
RETURNS BIT

Parameters

  • path: The path to search for an extension.

Returns

true if the characters that follow the last directory separator (\ or /) or volume separator (:) in the path include a period (.) followed by one or more characters; otherwise, false.

Example

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

Contents