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