select * from bd_quexhz where quex collate Chinese_PRC_CS_AS_WS like '%KV%'
select * from bd_quexhz where quex collate Chinese_PRC_CS_AS_WS like '%kv%'
select * from bd_quexhz where quex collate Chinese_PRC_CS_AS_WS like '%Kv%'
select * from bd_quexhz where quex collate Chinese_PRC_CS_AS_WS like '%kV%'
select cd=datalength(quex) from bd_quexhz order by cd desc
update bd_quexhz set quex=replace(CAST(quex AS varchar(8000)),'KV','kV')
update bd_quexhz set quex=replace(CAST(quex AS varchar(8000)),'kv','kV')
update bd_quexhz set quex=replace(CAST(quex AS varchar(8000)),'Kv','kV')