SQLServer汉字(转拼音首字母,转全拼音函数)

方法一sqlserver汉字转拼音首字母

--方法一sqlserver汉字转拼音首字母
--调用方法 select dbo.procGetPY ('中國')

Create FUNCTION dbo.procGetPY 
( 
@str NVARCHAR(4000) 
) 
/*
select dbo. procGetPYFirstLetter ('中國')
*/
RETURNS NVARCHAR(4000) 
--WITH ENCRYPTION 
AS 
BEGIN 
DECLARE @WORD NCHAR(1),@PY NVARCHAR(4000) 

SET @PY='' 

WHILE LEN(@STR)>0 
BEGIN 
SET @WORD=LEFT(@STR,1) 

--如果非漢字字符﹐返回原字符 
SET @PY=@PY+(CASE WHEN UNICODE(@WORD) BETWEEN 19968 AND 19968+20901 
THEN ( 
SELECT TOP 1 PY 
FROM 
( 
SELECT 'A' AS PY,N'驁' AS WORD 
UNION ALL SELECT 'B',N'簿' 
UNION ALL SELECT 'C',N'錯' 
UNION ALL SELECT 'D',N'鵽' 
UNION ALL SELECT 'E',N'樲' 
UNION 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 'N',N'桛' 
UNION ALL SELECT 'O',N'漚' 
UNION ALL SELECT 'P',N'曝' 
UNION ALL SELECT 'Q',N'囕' 
UNION ALL SELECT 'R',N'鶸' 
UNION ALL SELECT 'S',N'蜶' 
UNION ALL SELECT 'T',N'籜' 
UNION ALL SELECT 'W',N'鶩' 
UNION ALL SELECT 'X',N'鑂' 
UNION ALL SELECT 'Y',N'韻' 
UNION ALL SELECT 'Z',N'做' 
) T 
WHERE WORD>=@WORD COLLATE CHINESE_PRC_CS_AS_KS_WS 
ORDER BY PY ASC 
) 
ELSE @WORD 
END) 
SET @STR=RIGHT(@STR,LEN(@STR)-1) 
END 

RETURN @PY 

END

Go

方法二sqlserver汉字转全拼

--方法二sqlserver汉字转全拼 
--调用方法 select dbo.fn_GetQuanPin('中國')

USE Test
go
  
IF OBJECT_ID('Fn_GetQuanPin','Fn') IS NOT NULL
    DROP FUNCTION fn_GetQuanPin
go
  
create function [dbo].[fn_GetQuanPin](@str varchar(100))
returns varchar(8000)
as
begin
 declare @re varchar(8000),@crs varchar(10)
 declare @strlen int
 select @strlen=len(@str),@re=''
 while @strlen>0
 begin 
  set @crs= substring(@str,@strlen,1)
      select @re=
        CASE
        when @crs<'吖' COLLATE Chinese_PRC_CS_AS_KS_WS then @crs
        when @crs<='厑' COLLATE Chinese_PRC_CS_AS_KS_WS then 'A'
        when @crs<='靉' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ai'
        when @crs<='黯' COLLATE Chinese_PRC_CS_AS_KS_WS then 'An'
        when @crs<='醠' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ang'
        when @crs<='驁' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ao'
        when @crs<='欛' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ba'
        when @crs<='瓸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bai'
        when @crs<='瓣' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ban'
        when @crs<='鎊' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bang'
        when @crs<='鑤' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bao'
        when @crs<='鐾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bei'
        when @crs<='輽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ben'
        when @crs<='鏰' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Beng'
        when @crs<='鼊' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bi'
        when @crs<='變' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bian'
        when @crs<='鰾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Biao'
        when @crs<='彆' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bie'
        when @crs<='鬢' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bin'
        when @crs<='靐' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bing'
        when @crs<='蔔' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bo'
        when @crs<='簿' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Bu'
        when @crs<='囃' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ca'
        when @crs<='乲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cai'
        when @crs<='爘' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Can'
        when @crs<='賶' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cang'
        when @crs<='鼜' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cao'
        when @crs<='簎' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ce'
        when @crs<='笒' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cen'
        when @crs<='乽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ceng'
        when @crs<='詫' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cha'
        when @crs<='囆' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chai'
        when @crs<='顫' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chan'
        when @crs<='韔' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chang'
        when @crs<='觘' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chao'
        when @crs<='爡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Che'
        when @crs<='讖' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chen'
        when @crs<='秤' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cheng'
        when @crs<='鷘' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chi'
        when @crs<='銃' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chong'
        when @crs<='殠' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chou'
        when @crs<='矗' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chu'
        when @crs<='踹' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chuai'
        when @crs<='鶨' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chuan'
        when @crs<='愴' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chuang'
        when @crs<='顀' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chui'
        when @crs<='蠢' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chun'
        when @crs<='縒' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Chuo'
        when @crs<='嗭' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ci'
        when @crs<='謥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cong'
        when @crs<='輳' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cou'
        when @crs<='顣' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cu'
        when @crs<='爨' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cuan'
        when @crs<='臎' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cui'
        when @crs<='籿' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cun'
        when @crs<='錯' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Cuo'
        when @crs<='橽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Da'
        when @crs<='靆' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dai'
        when @crs<='饏' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dan'
        when @crs<='闣' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dang'
        when @crs<='纛' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dao'
        when @crs<='的' COLLATE Chinese_PRC_CS_AS_KS_WS then 'De'
        when @crs<='扽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Den'
        when @crs<='鐙' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Deng'
        when @crs<='螮' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Di'
        when @crs<='嗲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dia'
        when @crs<='驔' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dian'
        when @crs<='鑃' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Diao'
        when @crs<='嚸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Die'
        when @crs<='顁' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ding'
        when @crs<='銩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Diu'
        when @crs<='霘' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dong'
        when @crs<='鬭' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dou'
        when @crs<='蠹' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Du'
        when @crs<='叾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Duan'
        when @crs<='譵' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dui'
        when @crs<='踲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Dun'
        when @crs<='鵽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Duo'
        when @crs<='鱷' COLLATE Chinese_PRC_CS_AS_KS_WS then 'E'
        when @crs<='摁' COLLATE Chinese_PRC_CS_AS_KS_WS then 'En'
        when @crs<='鞥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Eng'
        when @crs<='樲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Er'
        when @crs<='髮' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Fa'
        when @crs<='瀪' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Fan'
        when @crs<='放' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Fang'
        when @crs<='靅' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Fei'
        when @crs<='鱝' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Fen'
        when @crs<='覅' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Feng'
        when @crs<='梻' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Fo'
        when @crs<='鴀' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Fou'
        when @crs<='猤' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Fu'
        when @crs<='魀' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ga'
        when @crs<='瓂' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gai'
        when @crs<='灨' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gan'
        when @crs<='戇' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gang'
        when @crs<='鋯' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gao'
        when @crs<='獦' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ge'
        when @crs<='給' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gei'
        when @crs<='搄' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gen'
        when @crs<='堩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Geng'
        when @crs<='兣' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gong'
        when @crs<='購' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gou'
        when @crs<='顧' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gu'
        when @crs<='詿' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gua'
        when @crs<='恠' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Guai'
        when @crs<='鱹' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Guan'
        when @crs<='撗' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Guang'
        when @crs<='鱥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gui'
        when @crs<='謴' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Gun'
        when @crs<='腂' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Guo'
        when @crs<='哈' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ha'
        when @crs<='饚' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hai'
        when @crs<='鶾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Han'
        when @crs<='沆' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hang'
        when @crs<='兞' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hao'
        when @crs<='靏' COLLATE Chinese_PRC_CS_AS_KS_WS then 'He'
        when @crs<='嬒' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hei'
        when @crs<='恨' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hen'
        when @crs<='堼' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Heng'
        when @crs<='鬨' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hong'
        when @crs<='鱟' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hou'
        when @crs<='鸌' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hu'
        when @crs<='蘳' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hua'
        when @crs<='蘾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Huai'
        when @crs<='鰀' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Huan'
        when @crs<='鎤' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Huang'
        when @crs<='顪' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hui'
        when @crs<='諢' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Hun'
        when @crs<='夻' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Huo'
        when @crs<='驥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ji'
        when @crs<='嗧' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jia'
        when @crs<='鑳' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jian'
        when @crs<='謽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jiang'
        when @crs<='釂' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jiao'
        when @crs<='繲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jie'
        when @crs<='齽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jin'
        when @crs<='竸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jing'
        when @crs<='蘔' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jiong'
        when @crs<='欍' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jiu'
        when @crs<='爠' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ju'
        when @crs<='羂' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Juan'
        when @crs<='钁' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jue'
        when @crs<='攈' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Jun'
        when @crs<='鉲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ka'
        when @crs<='乫' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kai'
        when @crs<='矙' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kan'
        when @crs<='閌' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kang'
        when @crs<='鯌' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kao'
        when @crs<='騍' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ke'
        when @crs<='褃' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ken'
        when @crs<='鏗' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Keng'
        when @crs<='廤' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kong'
        when @crs<='鷇' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kou'
        when @crs<='嚳' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ku'
        when @crs<='骻' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kua'
        when @crs<='鱠' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kuai'
        when @crs<='窾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kuan'
        when @crs<='鑛' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kuang'
        when @crs<='鑎' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kui'
        when @crs<='睏' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kun'
        when @crs<='穒' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Kuo'
        when @crs<='鞡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'La'
        when @crs<='籟' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lai'
        when @crs<='糷' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lan'
        when @crs<='唥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lang'
        when @crs<='軂' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lao'
        when @crs<='餎' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Le'
        when @crs<='脷' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lei'
        when @crs<='睖' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Leng'
        when @crs<='瓈' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Li'
        when @crs<='倆' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lia'
        when @crs<='纞' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lian'
        when @crs<='鍄' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Liang'
        when @crs<='瞭' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Liao'
        when @crs<='鱲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lie'
        when @crs<='轥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lin'
        when @crs<='炩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ling'
        when @crs<='咯' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Liu'
        when @crs<='贚' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Long'
        when @crs<='鏤' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lou'
        when @crs<='氇' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lu'
        when @crs<='鑢' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lv'
        when @crs<='亂' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Luan'
        when @crs<='擽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lue'
        when @crs<='論' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Lun'
        when @crs<='鱳' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Luo'
        when @crs<='嘛' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ma'
        when @crs<='霢' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mai'
        when @crs<='蘰' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Man'
        when @crs<='蠎' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mang'
        when @crs<='唜' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mao'
        when @crs<='癦' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Me'
        when @crs<='嚜' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mei'
        when @crs<='們' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Men'
        when @crs<='霥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Meng'
        when @crs<='羃' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mi'
        when @crs<='麵' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mian'
        when @crs<='廟' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Miao'
        when @crs<='鱴' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mie'
        when @crs<='鰵' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Min'
        when @crs<='詺' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ming'
        when @crs<='謬' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Miu'
        when @crs<='耱' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mo'
        when @crs<='麰' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mou'
        when @crs<='旀' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Mu'
        when @crs<='魶' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Na'
        when @crs<='錼' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nai'
        when @crs<='婻' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nan'
        when @crs<='齉' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nang'
        when @crs<='臑' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nao'
        when @crs<='呢' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ne'
        when @crs<='焾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nei'
        when @crs<='嫩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nen'
        when @crs<='能' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Neng'
        when @crs<='嬺' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ni'
        when @crs<='艌' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nian'
        when @crs<='釀' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Niang'
        when @crs<='脲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Niao'
        when @crs<='钀' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nie'
        when @crs<='拰' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nin'
        when @crs<='濘' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ning'
        when @crs<='靵' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Niu'
        when @crs<='齈' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nong'
        when @crs<='譳' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nou'
        when @crs<='搙' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nu'
        when @crs<='衄' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nv'
        when @crs<='瘧' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nue'
        when @crs<='燶' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nuan'
        when @crs<='桛' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Nuo'
        when @crs<='鞰' COLLATE Chinese_PRC_CS_AS_KS_WS then 'O'
        when @crs<='漚' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ou'
        when @crs<='袙' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pa'
        when @crs<='磗' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pai'
        when @crs<='鑻' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pan'
        when @crs<='胖' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pang'
        when @crs<='礮' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pao'
        when @crs<='轡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pei'
        when @crs<='喯' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pen'
        when @crs<='喸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Peng'
        when @crs<='鸊' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pi'
        when @crs<='騙' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pian'
        when @crs<='慓' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Piao'
        when @crs<='嫳' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pie'
        when @crs<='聘' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pin'
        when @crs<='蘋' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ping'
        when @crs<='魄' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Po'
        when @crs<='哛' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pou'
        when @crs<='曝' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Pu'
        when @crs<='蟿' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qi'
        when @crs<='髂' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qia'
        when @crs<='縴' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qian'
        when @crs<='瓩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qiang'
        when @crs<='躈' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qiao'
        when @crs<='籡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qie'
        when @crs<='藽' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qin'
        when @crs<='櫦' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qing'
        when @crs<='瓗' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qiong'
        when @crs<='糗' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qiu'
        when @crs<='覻' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qu'
        when @crs<='勸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Quan'
        when @crs<='礭' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Que'
        when @crs<='囕' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Qun'
        when @crs<='橪' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ran'
        when @crs<='讓' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Rang'
        when @crs<='繞' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Rao'
        when @crs<='熱' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Re'
        when @crs<='餁' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ren'
        when @crs<='陾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Reng'
        when @crs<='馹' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ri'
        when @crs<='穃' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Rong'
        when @crs<='嶿' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Rou'
        when @crs<='擩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ru'
        when @crs<='礝' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ruan'
        when @crs<='壡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Rui'
        when @crs<='橍' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Run'
        when @crs<='鶸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ruo'
        when @crs<='栍' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sa'
        when @crs<='虄' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sai'
        when @crs<='閐' COLLATE Chinese_PRC_CS_AS_KS_WS then 'San'
        when @crs<='喪' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sang'
        when @crs<='髞' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sao'
        when @crs<='飋' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Se'
        when @crs<='篸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sen'
        when @crs<='縇' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Seng'
        when @crs<='霎' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sha'
        when @crs<='曬' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shai'
        when @crs<='鱔' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shan'
        when @crs<='緔' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shang'
        when @crs<='潲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shao'
        when @crs<='欇' COLLATE Chinese_PRC_CS_AS_KS_WS then 'She'
        when @crs<='瘮' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shen'
        when @crs<='賸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sheng'
        when @crs<='瓧' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shi'
        when @crs<='鏉' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shou'
        when @crs<='虪' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shu'
        when @crs<='誜' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shua'
        when @crs<='卛' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shuai'
        when @crs<='腨' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shuan'
        when @crs<='灀' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shuang'
        when @crs<='睡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shui'
        when @crs<='鬊' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shun'
        when @crs<='鑠' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Shuo'
        when @crs<='乺' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Si'
        when @crs<='鎹' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Song'
        when @crs<='瘶' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sou'
        when @crs<='鷫' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Su'
        when @crs<='算' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Suan'
        when @crs<='鐩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sui'
        when @crs<='潠' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Sun'
        when @crs<='蜶' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Suo'
        when @crs<='襨' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ta'
        when @crs<='燤' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tai'
        when @crs<='賧' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tan'
        when @crs<='燙' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tang'
        when @crs<='畓' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tao'
        when @crs<='蟘' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Te'
        when @crs<='朰' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Teng'
        when @crs<='趯' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ti'
        when @crs<='舚' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tian'
        when @crs<='糶' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tiao'
        when @crs<='餮' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tie'
        when @crs<='乭' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ting'
        when @crs<='憅' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tong'
        when @crs<='透' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tou'
        when @crs<='鵵' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tu'
        when @crs<='褖' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tuan'
        when @crs<='駾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tui'
        when @crs<='坉' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tun'
        when @crs<='籜' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Tuo'
        when @crs<='韤' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Wa'
        when @crs<='顡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Wai'
        when @crs<='贎' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Wan'
        when @crs<='朢' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Wang'
        when @crs<='躛' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Wei'
        when @crs<='璺' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Wen'
        when @crs<='齆' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Weng'
        when @crs<='齷' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Wo'
        when @crs<='鶩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Wu'
        when @crs<='衋' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xi'
        when @crs<='鏬' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xia'
        when @crs<='鼸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xian'
        when @crs<='鱌' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xiang'
        when @crs<='斆' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xiao'
        when @crs<='躞' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xie'
        when @crs<='釁' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xin'
        when @crs<='臖' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xing'
        when @crs<='敻' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xiong'
        when @crs<='齅' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xiu'
        when @crs<='蓿' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xu'
        when @crs<='贙' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xuan'
        when @crs<='瀥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xue'
        when @crs<='鑂' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Xun'
        when @crs<='齾' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ya'
        when @crs<='灩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yan'
        when @crs<='樣' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yang'
        when @crs<='鑰' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yao'
        when @crs<='岃' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ye'
        when @crs<='齸' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yi'
        when @crs<='檼' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yin'
        when @crs<='譍' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ying'
        when @crs<='喲' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yo'
        when @crs<='醟' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yong'
        when @crs<='鼬' COLLATE Chinese_PRC_CS_AS_KS_WS then 'You'
        when @crs<='爩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yu'
        when @crs<='願' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yuan'
        when @crs<='鸙' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yue'
        when @crs<='韻' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Yun'
        when @crs<='雥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Za'
        when @crs<='縡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zai'
        when @crs<='饡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zan'
        when @crs<='臟' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zang'
        when @crs<='竈' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zao'
        when @crs<='稄' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Ze'
        when @crs<='鱡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zei'
        when @crs<='囎' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zen'
        when @crs<='贈' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zeng'
        when @crs<='醡' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zha'
        when @crs<='瘵' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhai'
        when @crs<='驏' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhan'
        when @crs<='瞕' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhang'
        when @crs<='羄' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhao'
        when @crs<='鷓' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhe'
        when @crs<='黮' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhen'
        when @crs<='證' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zheng'
        when @crs<='豒' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhi'
        when @crs<='諥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhong'
        when @crs<='驟' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhou'
        when @crs<='鑄' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhu'
        when @crs<='爪' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhua'
        when @crs<='跩' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhuai'
        when @crs<='籑' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhuan'
        when @crs<='戅' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhuang'
        when @crs<='鑆' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhui'
        when @crs<='稕' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhun'
        when @crs<='籱' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zhuo'
        when @crs<='漬' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zi'
        when @crs<='縱' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zong'
        when @crs<='媰' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zou'
        when @crs<='謯' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zu'
        when @crs<='攥' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zuan'
        when @crs<='欈' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zui'
        when @crs<='銌' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zun'
        when @crs<='咗' COLLATE Chinese_PRC_CS_AS_KS_WS then 'Zuo'
        else  @crs end+@re,@strlen=@strlen-1
   end
 return(@re)
END

方法二sqlserver汉字转全拼(小写)

USE Test
go
  
IF OBJECT_ID('fn_ConvertQuanPin','Fn') IS NOT NULL
    DROP FUNCTION fn_GetQuanPin
go
  
create function [dbo].[fn_ConvertQuanPin](@str varchar(100))
returns varchar(8000)
as
begin
 declare @re varchar(8000),@crs varchar(10)
 declare @strlen int
 select @strlen=len(@str),@re=''
 while @strlen>0
 begin 
  set @crs= substring(@str,@strlen,1)
       select @re=
        case
        when @crs<'吖' collate chinese_prc_cs_as_ks_ws then @crs
        when @crs<='厑' collate chinese_prc_cs_as_ks_ws then 'a'
        when @crs<='靉' collate chinese_prc_cs_as_ks_ws then 'ai'
        when @crs<='黯' collate chinese_prc_cs_as_ks_ws then 'an'
        when @crs<='醠' collate chinese_prc_cs_as_ks_ws then 'ang'
        when @crs<='驁' collate chinese_prc_cs_as_ks_ws then 'ao'
        when @crs<='欛' collate chinese_prc_cs_as_ks_ws then 'ba'
        when @crs<='瓸' collate chinese_prc_cs_as_ks_ws then 'bai'
        when @crs<='瓣' collate chinese_prc_cs_as_ks_ws then 'ban'
        when @crs<='鎊' collate chinese_prc_cs_as_ks_ws then 'bang'
        when @crs<='鑤' collate chinese_prc_cs_as_ks_ws then 'bao'
        when @crs<='鐾' collate chinese_prc_cs_as_ks_ws then 'bei'
        when @crs<='輽' collate chinese_prc_cs_as_ks_ws then 'ben'
        when @crs<='鏰' collate chinese_prc_cs_as_ks_ws then 'beng'
        when @crs<='鼊' collate chinese_prc_cs_as_ks_ws then 'bi'
        when @crs<='變' collate chinese_prc_cs_as_ks_ws then 'bian'
        when @crs<='鰾' collate chinese_prc_cs_as_ks_ws then 'biao'
        when @crs<='彆' collate chinese_prc_cs_as_ks_ws then 'bie'
        when @crs<='鬢' collate chinese_prc_cs_as_ks_ws then 'bin'
        when @crs<='靐' collate chinese_prc_cs_as_ks_ws then 'bing'
        when @crs<='蔔' collate chinese_prc_cs_as_ks_ws then 'bo'
        when @crs<='簿' collate chinese_prc_cs_as_ks_ws then 'bu'
        when @crs<='囃' collate chinese_prc_cs_as_ks_ws then 'ca'
        when @crs<='乲' collate chinese_prc_cs_as_ks_ws then 'cai'
        when @crs<='爘' collate chinese_prc_cs_as_ks_ws then 'can'
        when @crs<='賶' collate chinese_prc_cs_as_ks_ws then 'cang'
        when @crs<='鼜' collate chinese_prc_cs_as_ks_ws then 'cao'
        when @crs<='簎' collate chinese_prc_cs_as_ks_ws then 'ce'
        when @crs<='笒' collate chinese_prc_cs_as_ks_ws then 'cen'
        when @crs<='乽' collate chinese_prc_cs_as_ks_ws then 'ceng'
        when @crs<='詫' collate chinese_prc_cs_as_ks_ws then 'cha'
        when @crs<='囆' collate chinese_prc_cs_as_ks_ws then 'chai'
        when @crs<='顫' collate chinese_prc_cs_as_ks_ws then 'chan'
        when @crs<='韔' collate chinese_prc_cs_as_ks_ws then 'chang'
        when @crs<='觘' collate chinese_prc_cs_as_ks_ws then 'chao'
        when @crs<='爡' collate chinese_prc_cs_as_ks_ws then 'che'
        when @crs<='讖' collate chinese_prc_cs_as_ks_ws then 'chen'
        when @crs<='秤' collate chinese_prc_cs_as_ks_ws then 'cheng'
        when @crs<='鷘' collate chinese_prc_cs_as_ks_ws then 'chi'
        when @crs<='銃' collate chinese_prc_cs_as_ks_ws then 'chong'
        when @crs<='殠' collate chinese_prc_cs_as_ks_ws then 'chou'
        when @crs<='矗' collate chinese_prc_cs_as_ks_ws then 'chu'
        when @crs<='踹' collate chinese_prc_cs_as_ks_ws then 'chuai'
        when @crs<='鶨' collate chinese_prc_cs_as_ks_ws then 'chuan'
        when @crs<='愴' collate chinese_prc_cs_as_ks_ws then 'chuang'
        when @crs<='顀' collate chinese_prc_cs_as_ks_ws then 'chui'
        when @crs<='蠢' collate chinese_prc_cs_as_ks_ws then 'chun'
        when @crs<='縒' collate chinese_prc_cs_as_ks_ws then 'chuo'
        when @crs<='嗭' collate chinese_prc_cs_as_ks_ws then 'ci'
        when @crs<='謥' collate chinese_prc_cs_as_ks_ws then 'cong'
        when @crs<='輳' collate chinese_prc_cs_as_ks_ws then 'cou'
        when @crs<='顣' collate chinese_prc_cs_as_ks_ws then 'cu'
        when @crs<='爨' collate chinese_prc_cs_as_ks_ws then 'cuan'
        when @crs<='臎' collate chinese_prc_cs_as_ks_ws then 'cui'
        when @crs<='籿' collate chinese_prc_cs_as_ks_ws then 'cun'
        when @crs<='錯' collate chinese_prc_cs_as_ks_ws then 'cuo'
        when @crs<='橽' collate chinese_prc_cs_as_ks_ws then 'da'
        when @crs<='靆' collate chinese_prc_cs_as_ks_ws then 'dai'
        when @crs<='饏' collate chinese_prc_cs_as_ks_ws then 'dan'
        when @crs<='闣' collate chinese_prc_cs_as_ks_ws then 'dang'
        when @crs<='纛' collate chinese_prc_cs_as_ks_ws then 'dao'
        when @crs<='的' collate chinese_prc_cs_as_ks_ws then 'de'
        when @crs<='扽' collate chinese_prc_cs_as_ks_ws then 'den'
        when @crs<='鐙' collate chinese_prc_cs_as_ks_ws then 'deng'
        when @crs<='螮' collate chinese_prc_cs_as_ks_ws then 'di'
        when @crs<='嗲' collate chinese_prc_cs_as_ks_ws then 'dia'
        when @crs<='驔' collate chinese_prc_cs_as_ks_ws then 'dian'
        when @crs<='鑃' collate chinese_prc_cs_as_ks_ws then 'diao'
        when @crs<='嚸' collate chinese_prc_cs_as_ks_ws then 'die'
        when @crs<='顁' collate chinese_prc_cs_as_ks_ws then 'ding'
        when @crs<='銩' collate chinese_prc_cs_as_ks_ws then 'diu'
        when @crs<='霘' collate chinese_prc_cs_as_ks_ws then 'dong'
        when @crs<='鬭' collate chinese_prc_cs_as_ks_ws then 'dou'
        when @crs<='蠹' collate chinese_prc_cs_as_ks_ws then 'du'
        when @crs<='叾' collate chinese_prc_cs_as_ks_ws then 'duan'
        when @crs<='譵' collate chinese_prc_cs_as_ks_ws then 'dui'
        when @crs<='踲' collate chinese_prc_cs_as_ks_ws then 'dun'
        when @crs<='鵽' collate chinese_prc_cs_as_ks_ws then 'duo'
        when @crs<='鱷' collate chinese_prc_cs_as_ks_ws then 'e'
        when @crs<='摁' collate chinese_prc_cs_as_ks_ws then 'en'
        when @crs<='鞥' collate chinese_prc_cs_as_ks_ws then 'eng'
        when @crs<='樲' collate chinese_prc_cs_as_ks_ws then 'er'
        when @crs<='髮' collate chinese_prc_cs_as_ks_ws then 'fa'
        when @crs<='瀪' collate chinese_prc_cs_as_ks_ws then 'fan'
        when @crs<='放' collate chinese_prc_cs_as_ks_ws then 'fang'
        when @crs<='靅' collate chinese_prc_cs_as_ks_ws then 'fei'
        when @crs<='鱝' collate chinese_prc_cs_as_ks_ws then 'fen'
        when @crs<='覅' collate chinese_prc_cs_as_ks_ws then 'feng'
        when @crs<='梻' collate chinese_prc_cs_as_ks_ws then 'fo'
        when @crs<='鴀' collate chinese_prc_cs_as_ks_ws then 'fou'
        when @crs<='猤' collate chinese_prc_cs_as_ks_ws then 'fu'
        when @crs<='魀' collate chinese_prc_cs_as_ks_ws then 'ga'
        when @crs<='瓂' collate chinese_prc_cs_as_ks_ws then 'gai'
        when @crs<='灨' collate chinese_prc_cs_as_ks_ws then 'gan'
        when @crs<='戇' collate chinese_prc_cs_as_ks_ws then 'gang'
        when @crs<='鋯' collate chinese_prc_cs_as_ks_ws then 'gao'
        when @crs<='獦' collate chinese_prc_cs_as_ks_ws then 'ge'
        when @crs<='給' collate chinese_prc_cs_as_ks_ws then 'gei'
        when @crs<='搄' collate chinese_prc_cs_as_ks_ws then 'gen'
        when @crs<='堩' collate chinese_prc_cs_as_ks_ws then 'geng'
        when @crs<='兣' collate chinese_prc_cs_as_ks_ws then 'gong'
        when @crs<='購' collate chinese_prc_cs_as_ks_ws then 'gou'
        when @crs<='顧' collate chinese_prc_cs_as_ks_ws then 'gu'
        when @crs<='詿' collate chinese_prc_cs_as_ks_ws then 'gua'
        when @crs<='恠' collate chinese_prc_cs_as_ks_ws then 'guai'
        when @crs<='鱹' collate chinese_prc_cs_as_ks_ws then 'guan'
        when @crs<='撗' collate chinese_prc_cs_as_ks_ws then 'guang'
        when @crs<='鱥' collate chinese_prc_cs_as_ks_ws then 'gui'
        when @crs<='謴' collate chinese_prc_cs_as_ks_ws then 'gun'
        when @crs<='腂' collate chinese_prc_cs_as_ks_ws then 'guo'
        when @crs<='哈' collate chinese_prc_cs_as_ks_ws then 'ha'
        when @crs<='饚' collate chinese_prc_cs_as_ks_ws then 'hai'
        when @crs<='鶾' collate chinese_prc_cs_as_ks_ws then 'han'
        when @crs<='沆' collate chinese_prc_cs_as_ks_ws then 'hang'
        when @crs<='兞' collate chinese_prc_cs_as_ks_ws then 'hao'
        when @crs<='靏' collate chinese_prc_cs_as_ks_ws then 'he'
        when @crs<='嬒' collate chinese_prc_cs_as_ks_ws then 'hei'
        when @crs<='恨' collate chinese_prc_cs_as_ks_ws then 'hen'
        when @crs<='堼' collate chinese_prc_cs_as_ks_ws then 'heng'
        when @crs<='鬨' collate chinese_prc_cs_as_ks_ws then 'hong'
        when @crs<='鱟' collate chinese_prc_cs_as_ks_ws then 'hou'
        when @crs<='鸌' collate chinese_prc_cs_as_ks_ws then 'hu'
        when @crs<='蘳' collate chinese_prc_cs_as_ks_ws then 'hua'
        when @crs<='蘾' collate chinese_prc_cs_as_ks_ws then 'huai'
        when @crs<='鰀' collate chinese_prc_cs_as_ks_ws then 'huan'
        when @crs<='鎤' collate chinese_prc_cs_as_ks_ws then 'huang'
        when @crs<='顪' collate chinese_prc_cs_as_ks_ws then 'hui'
        when @crs<='諢' collate chinese_prc_cs_as_ks_ws then 'hun'
        when @crs<='夻' collate chinese_prc_cs_as_ks_ws then 'huo'
        when @crs<='驥' collate chinese_prc_cs_as_ks_ws then 'ji'
        when @crs<='嗧' collate chinese_prc_cs_as_ks_ws then 'jia'
        when @crs<='鑳' collate chinese_prc_cs_as_ks_ws then 'jian'
        when @crs<='謽' collate chinese_prc_cs_as_ks_ws then 'jiang'
        when @crs<='釂' collate chinese_prc_cs_as_ks_ws then 'jiao'
        when @crs<='繲' collate chinese_prc_cs_as_ks_ws then 'jie'
        when @crs<='齽' collate chinese_prc_cs_as_ks_ws then 'jin'
        when @crs<='竸' collate chinese_prc_cs_as_ks_ws then 'jing'
        when @crs<='蘔' collate chinese_prc_cs_as_ks_ws then 'jiong'
        when @crs<='欍' collate chinese_prc_cs_as_ks_ws then 'jiu'
        when @crs<='爠' collate chinese_prc_cs_as_ks_ws then 'ju'
        when @crs<='羂' collate chinese_prc_cs_as_ks_ws then 'juan'
        when @crs<='钁' collate chinese_prc_cs_as_ks_ws then 'jue'
        when @crs<='攈' collate chinese_prc_cs_as_ks_ws then 'jun'
        when @crs<='鉲' collate chinese_prc_cs_as_ks_ws then 'ka'
        when @crs<='乫' collate chinese_prc_cs_as_ks_ws then 'kai'
        when @crs<='矙' collate chinese_prc_cs_as_ks_ws then 'kan'
        when @crs<='閌' collate chinese_prc_cs_as_ks_ws then 'kang'
        when @crs<='鯌' collate chinese_prc_cs_as_ks_ws then 'kao'
        when @crs<='騍' collate chinese_prc_cs_as_ks_ws then 'ke'
        when @crs<='褃' collate chinese_prc_cs_as_ks_ws then 'ken'
        when @crs<='鏗' collate chinese_prc_cs_as_ks_ws then 'keng'
        when @crs<='廤' collate chinese_prc_cs_as_ks_ws then 'kong'
        when @crs<='鷇' collate chinese_prc_cs_as_ks_ws then 'kou'
        when @crs<='嚳' collate chinese_prc_cs_as_ks_ws then 'ku'
        when @crs<='骻' collate chinese_prc_cs_as_ks_ws then 'kua'
        when @crs<='鱠' collate chinese_prc_cs_as_ks_ws then 'kuai'
        when @crs<='窾' collate chinese_prc_cs_as_ks_ws then 'kuan'
        when @crs<='鑛' collate chinese_prc_cs_as_ks_ws then 'kuang'
        when @crs<='鑎' collate chinese_prc_cs_as_ks_ws then 'kui'
        when @crs<='睏' collate chinese_prc_cs_as_ks_ws then 'kun'
        when @crs<='穒' collate chinese_prc_cs_as_ks_ws then 'kuo'
        when @crs<='鞡' collate chinese_prc_cs_as_ks_ws then 'la'
        when @crs<='籟' collate chinese_prc_cs_as_ks_ws then 'lai'
        when @crs<='糷' collate chinese_prc_cs_as_ks_ws then 'lan'
        when @crs<='唥' collate chinese_prc_cs_as_ks_ws then 'lang'
        when @crs<='軂' collate chinese_prc_cs_as_ks_ws then 'lao'
        when @crs<='餎' collate chinese_prc_cs_as_ks_ws then 'le'
        when @crs<='脷' collate chinese_prc_cs_as_ks_ws then 'lei'
        when @crs<='睖' collate chinese_prc_cs_as_ks_ws then 'leng'
        when @crs<='瓈' collate chinese_prc_cs_as_ks_ws then 'li'
        when @crs<='倆' collate chinese_prc_cs_as_ks_ws then 'lia'
        when @crs<='纞' collate chinese_prc_cs_as_ks_ws then 'lian'
        when @crs<='鍄' collate chinese_prc_cs_as_ks_ws then 'liang'
        when @crs<='瞭' collate chinese_prc_cs_as_ks_ws then 'liao'
        when @crs<='鱲' collate chinese_prc_cs_as_ks_ws then 'lie'
        when @crs<='轥' collate chinese_prc_cs_as_ks_ws then 'lin'
        when @crs<='炩' collate chinese_prc_cs_as_ks_ws then 'ling'
        when @crs<='咯' collate chinese_prc_cs_as_ks_ws then 'liu'
        when @crs<='贚' collate chinese_prc_cs_as_ks_ws then 'long'
        when @crs<='鏤' collate chinese_prc_cs_as_ks_ws then 'lou'
        when @crs<='氇' collate chinese_prc_cs_as_ks_ws then 'lu'
        when @crs<='鑢' collate chinese_prc_cs_as_ks_ws then 'lv'
        when @crs<='亂' collate chinese_prc_cs_as_ks_ws then 'luan'
        when @crs<='擽' collate chinese_prc_cs_as_ks_ws then 'lue'
        when @crs<='論' collate chinese_prc_cs_as_ks_ws then 'lun'
        when @crs<='鱳' collate chinese_prc_cs_as_ks_ws then 'luo'
        when @crs<='嘛' collate chinese_prc_cs_as_ks_ws then 'ma'
        when @crs<='霢' collate chinese_prc_cs_as_ks_ws then 'mai'
        when @crs<='蘰' collate chinese_prc_cs_as_ks_ws then 'man'
        when @crs<='蠎' collate chinese_prc_cs_as_ks_ws then 'mang'
        when @crs<='唜' collate chinese_prc_cs_as_ks_ws then 'mao'
        when @crs<='癦' collate chinese_prc_cs_as_ks_ws then 'me'
        when @crs<='嚜' collate chinese_prc_cs_as_ks_ws then 'mei'
        when @crs<='們' collate chinese_prc_cs_as_ks_ws then 'men'
        when @crs<='霥' collate chinese_prc_cs_as_ks_ws then 'meng'
        when @crs<='羃' collate chinese_prc_cs_as_ks_ws then 'mi'
        when @crs<='麵' collate chinese_prc_cs_as_ks_ws then 'mian'
        when @crs<='廟' collate chinese_prc_cs_as_ks_ws then 'miao'
        when @crs<='鱴' collate chinese_prc_cs_as_ks_ws then 'mie'
        when @crs<='鰵' collate chinese_prc_cs_as_ks_ws then 'min'
        when @crs<='詺' collate chinese_prc_cs_as_ks_ws then 'ming'
        when @crs<='謬' collate chinese_prc_cs_as_ks_ws then 'miu'
        when @crs<='耱' collate chinese_prc_cs_as_ks_ws then 'mo'
        when @crs<='麰' collate chinese_prc_cs_as_ks_ws then 'mou'
        when @crs<='旀' collate chinese_prc_cs_as_ks_ws then 'mu'
        when @crs<='魶' collate chinese_prc_cs_as_ks_ws then 'na'
        when @crs<='錼' collate chinese_prc_cs_as_ks_ws then 'nai'
        when @crs<='婻' collate chinese_prc_cs_as_ks_ws then 'nan'
        when @crs<='齉' collate chinese_prc_cs_as_ks_ws then 'nang'
        when @crs<='臑' collate chinese_prc_cs_as_ks_ws then 'nao'
        when @crs<='呢' collate chinese_prc_cs_as_ks_ws then 'ne'
        when @crs<='焾' collate chinese_prc_cs_as_ks_ws then 'nei'
        when @crs<='嫩' collate chinese_prc_cs_as_ks_ws then 'nen'
        when @crs<='能' collate chinese_prc_cs_as_ks_ws then 'neng'
        when @crs<='嬺' collate chinese_prc_cs_as_ks_ws then 'ni'
        when @crs<='艌' collate chinese_prc_cs_as_ks_ws then 'nian'
        when @crs<='釀' collate chinese_prc_cs_as_ks_ws then 'niang'
        when @crs<='脲' collate chinese_prc_cs_as_ks_ws then 'niao'
        when @crs<='钀' collate chinese_prc_cs_as_ks_ws then 'nie'
        when @crs<='拰' collate chinese_prc_cs_as_ks_ws then 'nin'
        when @crs<='濘' collate chinese_prc_cs_as_ks_ws then 'ning'
        when @crs<='靵' collate chinese_prc_cs_as_ks_ws then 'niu'
        when @crs<='齈' collate chinese_prc_cs_as_ks_ws then 'nong'
        when @crs<='譳' collate chinese_prc_cs_as_ks_ws then 'nou'
        when @crs<='搙' collate chinese_prc_cs_as_ks_ws then 'nu'
        when @crs<='衄' collate chinese_prc_cs_as_ks_ws then 'nv'
        when @crs<='瘧' collate chinese_prc_cs_as_ks_ws then 'nue'
        when @crs<='燶' collate chinese_prc_cs_as_ks_ws then 'nuan'
        when @crs<='桛' collate chinese_prc_cs_as_ks_ws then 'nuo'
        when @crs<='鞰' collate chinese_prc_cs_as_ks_ws then 'o'
        when @crs<='漚' collate chinese_prc_cs_as_ks_ws then 'ou'
        when @crs<='袙' collate chinese_prc_cs_as_ks_ws then 'pa'
        when @crs<='磗' collate chinese_prc_cs_as_ks_ws then 'pai'
        when @crs<='鑻' collate chinese_prc_cs_as_ks_ws then 'pan'
        when @crs<='胖' collate chinese_prc_cs_as_ks_ws then 'pang'
        when @crs<='礮' collate chinese_prc_cs_as_ks_ws then 'pao'
        when @crs<='轡' collate chinese_prc_cs_as_ks_ws then 'pei'
        when @crs<='喯' collate chinese_prc_cs_as_ks_ws then 'pen'
        when @crs<='喸' collate chinese_prc_cs_as_ks_ws then 'peng'
        when @crs<='鸊' collate chinese_prc_cs_as_ks_ws then 'pi'
        when @crs<='騙' collate chinese_prc_cs_as_ks_ws then 'pian'
        when @crs<='慓' collate chinese_prc_cs_as_ks_ws then 'piao'
        when @crs<='嫳' collate chinese_prc_cs_as_ks_ws then 'pie'
        when @crs<='聘' collate chinese_prc_cs_as_ks_ws then 'pin'
        when @crs<='蘋' collate chinese_prc_cs_as_ks_ws then 'ping'
        when @crs<='魄' collate chinese_prc_cs_as_ks_ws then 'po'
        when @crs<='哛' collate chinese_prc_cs_as_ks_ws then 'pou'
        when @crs<='曝' collate chinese_prc_cs_as_ks_ws then 'pu'
        when @crs<='蟿' collate chinese_prc_cs_as_ks_ws then 'qi'
        when @crs<='髂' collate chinese_prc_cs_as_ks_ws then 'qia'
        when @crs<='縴' collate chinese_prc_cs_as_ks_ws then 'qian'
        when @crs<='瓩' collate chinese_prc_cs_as_ks_ws then 'qiang'
        when @crs<='躈' collate chinese_prc_cs_as_ks_ws then 'qiao'
        when @crs<='籡' collate chinese_prc_cs_as_ks_ws then 'qie'
        when @crs<='藽' collate chinese_prc_cs_as_ks_ws then 'qin'
        when @crs<='櫦' collate chinese_prc_cs_as_ks_ws then 'qing'
        when @crs<='瓗' collate chinese_prc_cs_as_ks_ws then 'qiong'
        when @crs<='糗' collate chinese_prc_cs_as_ks_ws then 'qiu'
        when @crs<='覻' collate chinese_prc_cs_as_ks_ws then 'qu'
        when @crs<='勸' collate chinese_prc_cs_as_ks_ws then 'quan'
        when @crs<='礭' collate chinese_prc_cs_as_ks_ws then 'que'
        when @crs<='囕' collate chinese_prc_cs_as_ks_ws then 'qun'
        when @crs<='橪' collate chinese_prc_cs_as_ks_ws then 'ran'
        when @crs<='讓' collate chinese_prc_cs_as_ks_ws then 'rang'
        when @crs<='繞' collate chinese_prc_cs_as_ks_ws then 'rao'
        when @crs<='熱' collate chinese_prc_cs_as_ks_ws then 're'
        when @crs<='餁' collate chinese_prc_cs_as_ks_ws then 'ren'
        when @crs<='陾' collate chinese_prc_cs_as_ks_ws then 'reng'
        when @crs<='馹' collate chinese_prc_cs_as_ks_ws then 'ri'
        when @crs<='穃' collate chinese_prc_cs_as_ks_ws then 'rong'
        when @crs<='嶿' collate chinese_prc_cs_as_ks_ws then 'rou'
        when @crs<='擩' collate chinese_prc_cs_as_ks_ws then 'ru'
        when @crs<='礝' collate chinese_prc_cs_as_ks_ws then 'ruan'
        when @crs<='壡' collate chinese_prc_cs_as_ks_ws then 'rui'
        when @crs<='橍' collate chinese_prc_cs_as_ks_ws then 'run'
        when @crs<='鶸' collate chinese_prc_cs_as_ks_ws then 'ruo'
        when @crs<='栍' collate chinese_prc_cs_as_ks_ws then 'sa'
        when @crs<='虄' collate chinese_prc_cs_as_ks_ws then 'sai'
        when @crs<='閐' collate chinese_prc_cs_as_ks_ws then 'san'
        when @crs<='喪' collate chinese_prc_cs_as_ks_ws then 'sang'
        when @crs<='髞' collate chinese_prc_cs_as_ks_ws then 'sao'
        when @crs<='飋' collate chinese_prc_cs_as_ks_ws then 'se'
        when @crs<='篸' collate chinese_prc_cs_as_ks_ws then 'sen'
        when @crs<='縇' collate chinese_prc_cs_as_ks_ws then 'seng'
        when @crs<='霎' collate chinese_prc_cs_as_ks_ws then 'sha'
        when @crs<='曬' collate chinese_prc_cs_as_ks_ws then 'shai'
        when @crs<='鱔' collate chinese_prc_cs_as_ks_ws then 'shan'
        when @crs<='緔' collate chinese_prc_cs_as_ks_ws then 'shang'
        when @crs<='潲' collate chinese_prc_cs_as_ks_ws then 'shao'
        when @crs<='欇' collate chinese_prc_cs_as_ks_ws then 'she'
        when @crs<='瘮' collate chinese_prc_cs_as_ks_ws then 'shen'
        when @crs<='賸' collate chinese_prc_cs_as_ks_ws then 'sheng'
        when @crs<='瓧' collate chinese_prc_cs_as_ks_ws then 'shi'
        when @crs<='鏉' collate chinese_prc_cs_as_ks_ws then 'shou'
        when @crs<='虪' collate chinese_prc_cs_as_ks_ws then 'shu'
        when @crs<='誜' collate chinese_prc_cs_as_ks_ws then 'shua'
        when @crs<='卛' collate chinese_prc_cs_as_ks_ws then 'shuai'
        when @crs<='腨' collate chinese_prc_cs_as_ks_ws then 'shuan'
        when @crs<='灀' collate chinese_prc_cs_as_ks_ws then 'shuang'
        when @crs<='睡' collate chinese_prc_cs_as_ks_ws then 'shui'
        when @crs<='鬊' collate chinese_prc_cs_as_ks_ws then 'shun'
        when @crs<='鑠' collate chinese_prc_cs_as_ks_ws then 'shuo'
        when @crs<='乺' collate chinese_prc_cs_as_ks_ws then 'si'
        when @crs<='鎹' collate chinese_prc_cs_as_ks_ws then 'song'
        when @crs<='瘶' collate chinese_prc_cs_as_ks_ws then 'sou'
        when @crs<='鷫' collate chinese_prc_cs_as_ks_ws then 'su'
        when @crs<='算' collate chinese_prc_cs_as_ks_ws then 'suan'
        when @crs<='鐩' collate chinese_prc_cs_as_ks_ws then 'sui'
        when @crs<='潠' collate chinese_prc_cs_as_ks_ws then 'sun'
        when @crs<='蜶' collate chinese_prc_cs_as_ks_ws then 'suo'
        when @crs<='襨' collate chinese_prc_cs_as_ks_ws then 'ta'
        when @crs<='燤' collate chinese_prc_cs_as_ks_ws then 'tai'
        when @crs<='賧' collate chinese_prc_cs_as_ks_ws then 'tan'
        when @crs<='燙' collate chinese_prc_cs_as_ks_ws then 'tang'
        when @crs<='畓' collate chinese_prc_cs_as_ks_ws then 'tao'
        when @crs<='蟘' collate chinese_prc_cs_as_ks_ws then 'te'
        when @crs<='朰' collate chinese_prc_cs_as_ks_ws then 'teng'
        when @crs<='趯' collate chinese_prc_cs_as_ks_ws then 'ti'
        when @crs<='舚' collate chinese_prc_cs_as_ks_ws then 'tian'
        when @crs<='糶' collate chinese_prc_cs_as_ks_ws then 'tiao'
        when @crs<='餮' collate chinese_prc_cs_as_ks_ws then 'tie'
        when @crs<='乭' collate chinese_prc_cs_as_ks_ws then 'ting'
        when @crs<='憅' collate chinese_prc_cs_as_ks_ws then 'tong'
        when @crs<='透' collate chinese_prc_cs_as_ks_ws then 'tou'
        when @crs<='鵵' collate chinese_prc_cs_as_ks_ws then 'tu'
        when @crs<='褖' collate chinese_prc_cs_as_ks_ws then 'tuan'
        when @crs<='駾' collate chinese_prc_cs_as_ks_ws then 'tui'
        when @crs<='坉' collate chinese_prc_cs_as_ks_ws then 'tun'
        when @crs<='籜' collate chinese_prc_cs_as_ks_ws then 'tuo'
        when @crs<='韤' collate chinese_prc_cs_as_ks_ws then 'wa'
        when @crs<='顡' collate chinese_prc_cs_as_ks_ws then 'wai'
        when @crs<='贎' collate chinese_prc_cs_as_ks_ws then 'wan'
        when @crs<='朢' collate chinese_prc_cs_as_ks_ws then 'wang'
        when @crs<='躛' collate chinese_prc_cs_as_ks_ws then 'wei'
        when @crs<='璺' collate chinese_prc_cs_as_ks_ws then 'wen'
        when @crs<='齆' collate chinese_prc_cs_as_ks_ws then 'weng'
        when @crs<='齷' collate chinese_prc_cs_as_ks_ws then 'wo'
        when @crs<='鶩' collate chinese_prc_cs_as_ks_ws then 'wu'
        when @crs<='衋' collate chinese_prc_cs_as_ks_ws then 'xi'
        when @crs<='鏬' collate chinese_prc_cs_as_ks_ws then 'xia'
        when @crs<='鼸' collate chinese_prc_cs_as_ks_ws then 'xian'
        when @crs<='鱌' collate chinese_prc_cs_as_ks_ws then 'xiang'
        when @crs<='斆' collate chinese_prc_cs_as_ks_ws then 'xiao'
        when @crs<='躞' collate chinese_prc_cs_as_ks_ws then 'xie'
        when @crs<='釁' collate chinese_prc_cs_as_ks_ws then 'xin'
        when @crs<='臖' collate chinese_prc_cs_as_ks_ws then 'xing'
        when @crs<='敻' collate chinese_prc_cs_as_ks_ws then 'xiong'
        when @crs<='齅' collate chinese_prc_cs_as_ks_ws then 'xiu'
        when @crs<='蓿' collate chinese_prc_cs_as_ks_ws then 'xu'
        when @crs<='贙' collate chinese_prc_cs_as_ks_ws then 'xuan'
        when @crs<='瀥' collate chinese_prc_cs_as_ks_ws then 'xue'
        when @crs<='鑂' collate chinese_prc_cs_as_ks_ws then 'xun'
        when @crs<='齾' collate chinese_prc_cs_as_ks_ws then 'ya'
        when @crs<='灩' collate chinese_prc_cs_as_ks_ws then 'yan'
        when @crs<='樣' collate chinese_prc_cs_as_ks_ws then 'yang'
        when @crs<='鑰' collate chinese_prc_cs_as_ks_ws then 'yao'
        when @crs<='岃' collate chinese_prc_cs_as_ks_ws then 'ye'
        when @crs<='齸' collate chinese_prc_cs_as_ks_ws then 'yi'
        when @crs<='檼' collate chinese_prc_cs_as_ks_ws then 'yin'
        when @crs<='譍' collate chinese_prc_cs_as_ks_ws then 'ying'
        when @crs<='喲' collate chinese_prc_cs_as_ks_ws then 'yo'
        when @crs<='醟' collate chinese_prc_cs_as_ks_ws then 'yong'
        when @crs<='鼬' collate chinese_prc_cs_as_ks_ws then 'you'
        when @crs<='爩' collate chinese_prc_cs_as_ks_ws then 'yu'
        when @crs<='願' collate chinese_prc_cs_as_ks_ws then 'yuan'
        when @crs<='鸙' collate chinese_prc_cs_as_ks_ws then 'yue'
        when @crs<='韻' collate chinese_prc_cs_as_ks_ws then 'yun'
        when @crs<='雥' collate chinese_prc_cs_as_ks_ws then 'za'
        when @crs<='縡' collate chinese_prc_cs_as_ks_ws then 'zai'
        when @crs<='饡' collate chinese_prc_cs_as_ks_ws then 'zan'
        when @crs<='臟' collate chinese_prc_cs_as_ks_ws then 'zang'
        when @crs<='竈' collate chinese_prc_cs_as_ks_ws then 'zao'
        when @crs<='稄' collate chinese_prc_cs_as_ks_ws then 'ze'
        when @crs<='鱡' collate chinese_prc_cs_as_ks_ws then 'zei'
        when @crs<='囎' collate chinese_prc_cs_as_ks_ws then 'zen'
        when @crs<='贈' collate chinese_prc_cs_as_ks_ws then 'zeng'
        when @crs<='醡' collate chinese_prc_cs_as_ks_ws then 'zha'
        when @crs<='瘵' collate chinese_prc_cs_as_ks_ws then 'zhai'
        when @crs<='驏' collate chinese_prc_cs_as_ks_ws then 'zhan'
        when @crs<='瞕' collate chinese_prc_cs_as_ks_ws then 'zhang'
        when @crs<='羄' collate chinese_prc_cs_as_ks_ws then 'zhao'
        when @crs<='鷓' collate chinese_prc_cs_as_ks_ws then 'zhe'
        when @crs<='黮' collate chinese_prc_cs_as_ks_ws then 'zhen'
        when @crs<='證' collate chinese_prc_cs_as_ks_ws then 'zheng'
        when @crs<='豒' collate chinese_prc_cs_as_ks_ws then 'zhi'
        when @crs<='諥' collate chinese_prc_cs_as_ks_ws then 'zhong'
        when @crs<='驟' collate chinese_prc_cs_as_ks_ws then 'zhou'
        when @crs<='鑄' collate chinese_prc_cs_as_ks_ws then 'zhu'
        when @crs<='爪' collate chinese_prc_cs_as_ks_ws then 'zhua'
        when @crs<='跩' collate chinese_prc_cs_as_ks_ws then 'zhuai'
        when @crs<='籑' collate chinese_prc_cs_as_ks_ws then 'zhuan'
        when @crs<='戅' collate chinese_prc_cs_as_ks_ws then 'zhuang'
        when @crs<='鑆' collate chinese_prc_cs_as_ks_ws then 'zhui'
        when @crs<='稕' collate chinese_prc_cs_as_ks_ws then 'zhun'
        when @crs<='籱' collate chinese_prc_cs_as_ks_ws then 'zhuo'
        when @crs<='漬' collate chinese_prc_cs_as_ks_ws then 'zi'
        when @crs<='縱' collate chinese_prc_cs_as_ks_ws then 'zong'
        when @crs<='媰' collate chinese_prc_cs_as_ks_ws then 'zou'
        when @crs<='謯' collate chinese_prc_cs_as_ks_ws then 'zu'
        when @crs<='攥' collate chinese_prc_cs_as_ks_ws then 'zuan'
        when @crs<='欈' collate chinese_prc_cs_as_ks_ws then 'zui'
        when @crs<='銌' collate chinese_prc_cs_as_ks_ws then 'zun'
        when @crs<='咗' collate chinese_prc_cs_as_ks_ws then 'zuo'
		--去掉拼音之间的间隔
        else  @crs end+@re,@strlen=@strlen-1
   end
 return(@re)
END

GO
SELECT dbo.fn_GetQuanPin('拿来主义')
/*
NaLaiZhuYi
*/

SELECT dbo.fn_ConvertQuanPin('拿来主义Super')
--nalaizhuyiSuper