sql - How do I do a simple 'Find and Replace" in MsSQL? -


question pretty self explanitory. want simple find , replace, in text editor on data in column of database (which mssql on ms windows server 2003)

the following query replace each , every a character b character.

update      yourtable set      column1 = replace(column1,'a','b')      column1 '%a%' 

this not work on sql server 2003.


Comments

Popular posts from this blog

windows - Why does Vista not allow creation of shortcuts to "Programs" on a NonAdmin account? Not supposed to install apps from NonAdmin account? -

c++ - How do I get a multi line tooltip in MFC -

unit testing - How to mock PreferenceManager in Android? -