Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Replace one string with another for all rows in a field
UPDATE DBNAME.TableName
SET DBNAME.TableName = REPLACE(DBNAME.TableName.FieldName,'OldString','NewString')
WHERE DBNAME.TableName.FieldName like '%OldString%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.