sql query replace all specific values with a different value

Question

I am attempting to replace specific values in one column with a new value but it does not work (no errors, no replacement of values, nothing happen).

UPDATE Components
SET Unit='kg'
WHERE Unit='КГ'

How can I replace all values "КГ" with "kg" in column Unit?

do you get any error, or the SQL statement is executed successfully? — Murtaza
– Murtaza, Commented Jul 7, 2014 at 4:28
be more clear. We don't even know if your problem is an error of if you simply don't know how to do. If this is the case, please even show some effort. Otherwise show us the error you are facing — Rafael Brasil
– Rafael Brasil, Commented Jul 7, 2014 at 4:32
Define does not work - do you get an error? If so: what error?? Does it not actually update the table? Or is something else happening?? WHAT is happening?? — marc_s
– marc_s, Commented Jul 7, 2014 at 4:32

mehdi lotfi · Accepted Answer · 2014-07-07 04:28:09Z

2

I thing that your Unit column is NVarChar() data type. Try following query:

UPDATE Components
SET Unit=N'kg'
WHERE Unit=N'КГ'

Another reason: If you have instead of update trigger on Components table and not update this column on it, your update not affected and no raise error too.

answered Jul 7, 2014 at 4:28

mehdi lotfi

11.6k18 gold badges85 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ajay2707 · Accepted Answer · 2014-07-07 06:08:18Z

1

I suggest to use Quotename to resolve this, it is used for this type of string.

UPDATE Components
SET Unit=QUOTENAME('kg')
WHERE Unit=QUOTENAME('КГ')

It is simple and direct query which you run, then its ok. Other wise as @Mehdi said, I also fever that statement.

http://www.c-sharpcorner.com/Blogs/7515/quotename-function-in-sql-server.aspx

answered Jul 7, 2014 at 6:08

Ajay2707

5,8286 gold badges44 silver badges61 bronze badges

Collectives™ on Stack Overflow

sql query replace all specific values with a different value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related