SQL Eval Function Path_ChangeExtension
Path_ChangeExtension
returns a new string in which all occurrences of a specified oldValye
Unicode character or String in the source
string are replaced with another specified newValue
Unicode character or String.
Path_ChangeExtension ( @path NVARCHAR (4000), @extension NVARCHAR (4000) ) RETURNS NVARCHAR (4000)
Parameters
- path: The path information to modify.
- extension: The new extension (with or without a leading period). Specify
null
to remove an existing extension frompath
.
Returns
- The modified path information.
Example
SELECT SQLNET::Path_ChangeExtension('C:\Temp\MyTest.txt', '.ext')