I am looking to make a TSQL statement that I can use to search for a particular string in a field and then then change it. I know the columns/fields that I need to search. Basically I have a 2 columns that store a full directory path including
the drive letter. Well I need to only change the drive letter.
I know the initial search which will give me all the rows that need to be changed will look like this:
SELECT * FROM MYTABLE WHERE MyField LIKE 'C:\%'
What I need to know is how to use the returned rows and then update the field with the new drive letter of F.
Can someone assist in this
Thank you in advance.
Go to the complete details ...