Figured it out.  It was a cloud thing. Backlashes needed to be forward slashes.

Thanks for looking at it though.

SELECT db.name AS database_name, mf.name as actual_logical_name,

LEFT(REVERSE(LEFT(REVERSE(mf.Physical_Name),CHARINDEX('\', REVERSE(mf.Physical_Name), 1) - 1)),

LEN(REVERSE(LEFT(REVERSE(mf.Physical_Name),CHARINDEX('\', REVERSE(mf.Physical_Name), 1) - 1))) - 4) as new__logical_name,

'ALTER DATABASE ['+db.name +'] MODIFY FILE (NAME=N'''+ mf.name + ''',NEWNAME=N'''+

LEFT(REVERSE(LEFT(REVERSE(mf.Physical_Name),CHARINDEX('\', REVERSE(mf.Physical_Name), 1)...

I've reattached the script as a *.txt file. The forum didn't accept the use of a *.sql file. Understandable.

It runs against all DBs, tables and dbnames are not relevant.

I found a solution that achieves the goal and thought I would share. The following script by Shiva Challa.

USE MASTER

GO

BEGIN

DECLARE @SQLVerNo INT;

SET @SQLVerNo = cast(substring(CAST(Serverproperty('ProductVersion') AS VARCHAR(50)) ,0,charindex('.',CAST(Serverproperty('ProductVersion') AS VARCHAR(50))...

Thanks. That is helpful information to keep me from spinning my wheels. 🙂