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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!