I'm looking to amend an SQL data field. The database is dbo.CaseInfo the field is FilePath. Currently the data field says 20170618041_06292017_145141_01.asf. I need to add the new network path to have it look like this.
There are over 20,000 entries and I'm looking for a query that will pull the 201706 as the indication of what I'm changing so that I can move a month worth of files at a time and change each month as I go by altering the query.