SQLServer汉字转全拼音函数

原文：?http://www.voidcn.com/article/p-dpsmzzev-baq.html

最近用到项目，当输入错别字时也需要匹配,直接网上找到一篇直接改写加了拼音排序，让语句更通用。拿来主义

1. USE?Test??
2. go??
3. ??
4. IF?OBJECT_ID('Fn_GetQuanPin','Fn')?IS?NOT?NULL??
5. ????DROP?FUNCTION?fn_GetQuanPin??
6. create?function?[dbo].[fn_GetQuanPin](@str?varchar(100))??
7. returns?varchar(8000)??
8. as??
9. begin??
10. ?declare?@re?varchar(8000),@crs?varchar(10)??
11. ?declare?@strlen?int???
12. select?@strlen=len(@str),@re=''??
13. ?while?@strlen>0??
14. begin????
15. ??set?@crs=?substring(@str,@strlen,1)??
16. ??????select?@re=??
17. ????????CASE???
18. ????????when?@crs<'吖'?COLLATE?Chinese_PRC_CS_AS_KS_WS?then?@crs??
19. ????????when?@crs<='厑'?then?'A'??
20. when?@crs<='靉'?then?'Ai'??
21. when?@crs<='黯'?then?'An'??
22. when?@crs<='醠'?then?'Ang'??
23. when?@crs<='驁'?then?'Ao'??
24. when?@crs<='欛'?then?'Ba'??
25. when?@crs<='瓸'?then?'Bai'??
26. when?@crs<='瓣'?then?'Ban'??
27. when?@crs<='鎊'?then?'Bang'??
28. when?@crs<='鑤'?then?'Bao'??
29. when?@crs<='鐾'?then?'Bei'??
30. when?@crs<='輽'?then?'Ben'??
31. when?@crs<='鏰'?then?'Beng'??
32. when?@crs<='鼊'?then?'Bi'??
33. when?@crs<='變'?then?'Bian'??
34. when?@crs<='鰾'?then?'Biao'??
35. when?@crs<='彆'?then?'Bie'??
36. when?@crs<='鬢'?then?'Bin'??
37. when?@crs<='靐'?then?'Bing'??
38. when?@crs<='蔔'?then?'Bo'??
39. when?@crs<='簿'?then?'Bu'??
40. when?@crs<='囃'?then?'Ca'??
41. when?@crs<='乲'?then?'Cai'??
42. when?@crs<='爘'?then?'Can'??
43. when?@crs<='賶'?then?'Cang'??
44. when?@crs<='鼜'?then?'Cao'??
45. when?@crs<='簎'?then?'Ce'??
46. when?@crs<='笒'?then?'Cen'??
47. when?@crs<='乽'?then?'Ceng'??
48. when?@crs<='詫'?then?'Cha'??
49. when?@crs<='囆'?then?'Chai'??
50. when?@crs<='顫'?then?'Chan'??
51. when?@crs<='韔'?then?'Chang'??
52. when?@crs<='觘'?then?'Chao'??
53. when?@crs<='爡'?then?'Che'??
54. when?@crs<='讖'?then?'Chen'??
55. when?@crs<='秤'?then?'Cheng'??
56. when?@crs<='鷘'?then?'Chi'??
57. when?@crs<='銃'?then?'Chong'??
58. when?@crs<='殠'?then?'Chou'??
59. when?@crs<='矗'?then?'Chu'??
60. when?@crs<='踹'?then?'Chuai'??
61. when?@crs<='鶨'?then?'Chuan'??
62. when?@crs<='愴'?then?'Chuang'??
63. when?@crs<='顀'?then?'Chui'??
64. when?@crs<='蠢'?then?'Chun'??
65. when?@crs<='縒'?then?'Chuo'??
66. when?@crs<='嗭'?then?'Ci'??
67. when?@crs<='謥'?then?'Cong'??
68. when?@crs<='輳'?then?'Cou'??
69. when?@crs<='顣'?then?'Cu'??
70. when?@crs<='爨'?then?'Cuan'??
71. when?@crs<='臎'?then?'Cui'??
72. when?@crs<='籿'?then?'Cun'??
73. when?@crs<='錯'?then?'Cuo'??
74. when?@crs<='

    （编辑：李大同）

    【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!