Declare @SQ char(1) Set @SQ = char(39) SELECT 'alter database BHCSECLPCPY modify file (name = [' + NAME + '] , FILENAME = ' + @SQ + 'P:\' + NAME + '\' + physical_name + @SQ + ')' + 'GO' FROM sys.database_files