Am out my depth here : I made this up - it returns NULL!

ALTER FUNCTION [dbo].[fn_DriveToUNC] (@Drive VARCHAR(3))

RETURNS varchar(1000)

-- RBriggs 10/07/2009

-- Get UNC path of drive letter

AS

BEGIN

declare@objWNet int

declare @UNC varchar(1000)

exec sp_OACreate 'WNetmpr', @objWNet out

exec sp_OAMethod @objWNet, 'WNetGetUniversalName', @UNC out, @drive

exec sp_OADestroy @objWNet

RETURN @UNC

END

go

SELECT dbo.fn_DriveToUNC('C:')

C# Gnu
____________________________________________________

Excel Database Tasks : efficient business data processing
Version 3.3 released February 2015