Mark Johns | SQLServerCentral

Mark Johns

Forum Replies Created

Viewing 2 posts - 1 through 3 (of 3 total)

RE: Update Query

SORTED!!!!

Update dbo.BulkImages
set FilePath = replace( FilePath, '\\server1\scanfiles2', '\\NAS1')
where filepath LIKE N'%JPG SCANNING%

Thanks guys!!!!

July 13, 2005 at 6:14 am

#573831
RE: Update Query

\\SERVER1\SCANFILES2\JPG SCANNING\PREVIEW TEST
\\SERVER1\SCANFILES2\JPG SCANNING\PREVIEW TEST
\\SERVER1\SCANFILES2\JPG SCANNING\PREVIEW TEST
\\SERVER1\SCANFILES2\JPG SCANNING\PREVIEW TEST
\\SERVER1\SCANFILES2\JPG SCANNING\PREVIEW TEST
Putting some thought into it its probably going to be...

July 13, 2005 at 4:31 am

#573812

Viewing 2 posts - 1 through 3 (of 3 total)