Manual link update query

From TrialWorks Wiki
Jump to: navigation, search

UPDATE IntakeDocuments SET Link = REPLACE(Link, '\\server1\TrialWorks\CaseFiles\','\\server2\TrialWorks\CaseFiles\') WHERE CHARINDEX ('\\server1\TrialWorks\CaseFiles\', Link) > 0