Home > IT Answers > SQL Server > Changing UNC paths
SQL Server Ask the Experts
2,585 pts.
 Changing UNC paths
SQL Server, UNC, UNC path
I have 138 rows of Universal Naming Convention (UNC) paths. Part of each path is constant and part is a variable. How do I change the constant portion of the UNC path and keep the variable intact? For example: •serverpathdir1dir11 •serverpathdir2 •serverpathdir3dir31 constant part "serverpath"

Software/Hardware used:
ASKED: June 12, 2009  4:26 PM
UPDATED: June 16, 2009  9:30 PM
RELATED QUESTIONS
Answer Wiki:
Use REPLACE function in the UPDATE statement.
Last Wiki Answer Submitted:  June 16, 2009  9:30 pm  by  msi77   1,610 pts.
All Answer Wiki Contributors:  msi77   1,610 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _