@PY=''
while len(@str)>0
begin
set @word=left(@str,1)
--如果非汉字字符,返回原字符
set @PY=@PY+(case when unicode...all select 'F',N'鰒'
union all select 'G',N'腂'
union all select 'H',N'夻'
union all select 'J',N'攈'...union all select 'K',N'穒'
union all select 'L',N'鱳'
union all select 'M',N'旀'
union all select '...'R',N'鶸'
union all select 'S',N'蜶'
union all select 'T',N'籜'
union all select 'W',N'鶩'
union all...set FHelpcode=dbo.fun_getPY(left(Fname,30))
go
--客户
update t_Organization set FHelpcode