sql函数：汉字转换为拼音

sql数据库
自定义一个函数
把下面代码写进去

功能是得到汉字拼音

 

 

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

go

 

 

select dbo.fn_Getquanpin (N'你好,我是月亮哥！')

go