thx John,

tinkering with something laborious I could finally pass the required string...the ' can bring a lot of confusion 🙂

DECLARE @BackupDrive NVARCHAR(100)

DECLARE @MergeComm NVARCHAR(500)

SET @BackupDrive = (select +'''' + SUBSTRING(physical_name,1,3)...

first, thank you very much for the quick response.

This is only the drive-name in a san-storage, among which are several mount points. so, I would like to save somewhere else,...