sniffdk/replace.sql

Last active November 16, 2018 17:31

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/sniffdk/5c000e1ac2ae6f47ab16db09c5af5918.js"></script>
Save sniffdk/5c000e1ac2ae6f47ab16db09c5af5918 to your computer and use it in GitHub Desktop.

Download ZIP

Replace ntext sql

Raw

replace.sql

 -- https://stackoverflow.com/a/4341677/701242
 UPDATE [table]
 SET [column] = CAST(REPLACE(CAST([column] as NVarchar(MAX)),'find','replace') AS NText)
 WHERE [column] LIKE '%find%'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment