insert into @geovindu select N’災’,’zai’
insert into @geovindu select N’兂’,’zan’
insert into @geovindu select N’牂’,’zang’
insert into @geovindu select N’遭’,’zao’
insert into @geovindu select N’啫’,’ze’
insert into @geovindu select N’贼’,’zei’
insert into @geovindu select N’怎’,’zen’
insert into @geovindu select N’曽’,’zeng’
insert into @geovindu select N’吒’,’zha’
insert into @geovindu select N’甴’,’gad’
insert into @geovindu select N’夈’,’zhai’
insert into @geovindu select N’毡’,’zhan’
insert into @geovindu select N’张’,’zhang’
insert into @geovindu select N’钊’,’zhao’
insert into @geovindu select N’蜇’,’zhe’
insert into @geovindu select N’贞’,’zhen’
insert into @geovindu select N’凧’,’zheng’
insert into @geovindu select N’之’,’zhi’
insert into @geovindu select N’中’,’zhong’
insert into @geovindu select N’州’,’zhou’
insert into @geovindu select N’劯’,’zhu’
insert into @geovindu select N’抓’,’zhua’
insert into @geovindu select N’专’,’zhuan’
insert into @geovindu select N’转’,’zhuai’
insert into @geovindu select N’妆’,’zhuang’
insert into @geovindu select N’骓’,’zhui’
insert into @geovindu select N’宒’,’zhun’
insert into @geovindu select N’卓’,’zhuo’
insert into @geovindu select N’孜’,’zi’
insert into @geovindu select N’唨’,’zo’
insert into @geovindu select N’宗’,’zong’
insert into @geovindu select N’棸’,’zou’
insert into @geovindu select N’哫’,’zu’
insert into @geovindu select N’劗’,’zuan’
insert into @geovindu select N’厜’,’zui’
insert into @geovindu select N’尊’,’zun’
insert into @geovindu select N’昨’,’zuo’
insert into @geovindu select N’孙’,’sun’
insert into @geovindu select N’斯’,’si’
declare @strlen int
select @strlen=len(@str),@re=”
while @strlen>0
begin
select top 1 @re=UPPER(substring(py,1,1) )+substring(py,2,len(py))+@re,@strlen=@strlen-1
from @geovindu a where chr<=substring(@str,@strlen,1)
order by chr collate Chinese_PRC_CS_AS_KS_WS desc
if @@rowcount=0
