sql - Replace word in row -


i need replace word in row in sql server table. i've table

id           value  1            k-numbers    2            j-number    3            l-number 

i need replace values in value column. in result

id           value  1            k-value  2            j-value  3            l-value 

how can this?

as you've written question, appear answer:

update t     set value = replace(replace(value, 'numbers', 'value'), 'number', 'value'); 

is need?


Comments

Popular posts from this blog

git - TortoiseGit does not show commit log properly -

string - Using python and postgres, variables within execute function? -