we sometimes copy a prod-DB to our test-Environment.
In the database is a table which contains filenames for some documents. The filenames are given with UNC-Pathnames like
I need to update these Filename to
The table has too many rows to do it manually and i don't have that much scripting-knowledge in T-SQL.
Could somebody give a clue how to do it?