pape pape - 9 months ago 43
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.


Below query might give the required output :-

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