pape pape - 1 year ago 84
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 Source

Below query might give the required output :-

select REPLACE([Last Name] COLLATE Cyrillic_General_CI_AI,'Ć','s')  FROM myTable1
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download