pape pape - 6 months ago 25
SQL Question

SQL replace č, ć, ž with letter c, z

I've got a table with column Last Name. I want to change a part of strings in the column.

select REPLACE([Last Name],'Ć','s') FROM myTable1


don't work.

If I put this

select REPLACE([Last Name],'o','s') FROM myTable1


it is work.

How to change č,ć,ž with another lettter.

Answer

Below query might give the required output :-

select REPLACE([Last Name] COLLATE Cyrillic_General_CI_AI,'Ć','s')  FROM myTable1
Comments