sql server自动生成拼音首字母的函数 建立一个查询，执行下面的语句生成函数fn_GetPy --生成拼音首码 CREATE function getInputstr(@str nvarchar(4000)) returns nvarchar(4000) --WITH ENCRYPTION as begin declare @intLen int declare @strRet nvarchar(4000) declare @temp nvarchar(100) set @intLen = len(@str) set @strRet = '' while @intLen > 0 begin set @temp = '' select @temp = case when substring(@str,@intLen,1) >= '帀' then when substring(@str,@intLen,1) >= '丫' then when substring(@str,@intLen,1) >= '夕' then when substring(@str,@intLen,1) >= '屲' then when substring(@str,@intLen,1) >= '他' then when substring(@str,@intLen,1) >= '仨' then when substring(@str,@intLen,1) >= '呥' then when substring(@str,@intLen,1) >= '七' then when substring(@str,@intLen,1) >= '妑' then when substring(@str,@intLen,1) >= '噢' then when substring(@str,@intLen,1) >= '拏' then when substring(@str,@intLen,1) >= '嘸' then when substring(@str,@intLen,1) >= '垃' then when substring(@str,@intLen,1) >= '咔' then when substring(@str,@intLen,1) >= '丌' then when substring(@str,@intLen,1) >= '铪' then when substring(@str,@intLen,1) >= '旮' then when substring(@str,@intLen,1) >= '发' then when substring(@str,@intLen,1) >= '妸' then when substring(@str,@intLen,1) >= '咑' then when substring(@str,@intLen,1) >= '嚓' then when substring(@str,@intLen,1) >= '八' then when substring(@str,@intLen,1) >= '吖' then else rtrim(ltrim(substring(@str,@intLen,1))) end --对于汉字特殊字符，不生成拼音码 'Z' 'Y' 'X' 'W' 'T' 'S' 'R' 'Q' 'P' 'O' 'N' 'M' 'L' 'K' 'J' 'H' 'G' 'F' 'E' 'D' 'C' 'B' 'A' if (ascii(@temp)>127) set @temp = '' --对于英文中小括号，不生成拼音码 if @temp = '(' or @temp = ')' set @temp = '' select @strRet = @temp + @strRet set @intLen = @intLen - 1 end return lower(@strRet) end 本文来源：https://www.wddqw.com/doc/9ee243dd71fe910ef12df8ef.html