That's great! I'm glad its helped, and thank you for letting me know.
I'd like to add your change to the original post if you have no objections?

Ah! I see.

Thank you, Budd 🙂

Budd (11/16/2016)

---

Nice Start, however.

SELECT TOP(1)

-- Get the path location by trimming the file name and file extension.

LEFT(physical_name,LEN(physical_name) - (LEN([name]) + 4) )

FROM sys.database_files

...