获得常用字汉字拼音的首个拼音字母首码,例举;Function HZToPY(cSTR:String):String; Var i:integer; S:String; begin Result:=''; for I := 1 to Length(cSTR) do begin S:=Copy(cSTR,i,1); if Trim(Getpinyin_shoupinma(S))='' then Result:=Result+S else Result:=Result+Getpinyin_shoup
建立一个查询,执行下面的语句生成函数fn_GetPy 代码如下: –生成拼音首码 CREATE function fn_GetPy(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 = ” w