CODEWITHSUNDEEP
sqlsql-server
Kirill
Kirill

Reputation: 193

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 to replace values in value column. In result

id           value

1            K-Value

2            J-Value

3            L-Value

How I can do this?

Upvotes: 0

Views: 65

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1269973

As you've written the question, this would appear to be the answer:

update t
    set value = replace(replace(value, 'Numbers', 'Value'), 'Number', 'Value');

Is that what you really need?

Upvotes: 1

Related Questions