Changing UNC paths
Home > IT Answers > Networking > Changing UNC paths
SQL Server Ask the Experts
2445 pts.
0
Q:
Changing UNC paths
UNC path, UNC, SQL Server
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"
ASKED: Jun 12 2009  4:26 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Msi77
800 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Use REPLACE function in the UPDATE statement.
Last Answered: Jun 16 2009  9:30 PM GMT by Msi77   800 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0