获得汉字字符串长度|获得汉字字符串的首字母

【www.bbyears.com--安卓教程】

--*/
if exists (select * from dbo.sysobjects where id = object_id(N"[dbo].[fGetPy]") and xtype in (N"FN", N"IF", N"TF"))
drop function [dbo].[fGetPy]
GO
--创建取拼音函数
create function fGetPy(@Str varchar(500)="")
returns varchar(500)
as
begin
    declare @strlen int,@return varchar(500),@ii int
    declare @n int,@c char(1),@chn nchar(1)
    select @strlen=len(@str),@return="",@ii=0
    set @ii=0
    while @ii<@strlen
    begin
        select @ii=@ii+1,@n=63,@chn=substring(@str,@ii,1)
        if @chn>"z"
        select @n = @n +1
          ,@c = case chn when @chn then char(@n) else @c end
       from(
           select top 27 * from (
          select chn = "吖"
          union all select "八"
          union all select "嚓"
          union all select "

本文来源：http://www.bbyears.com/shoujikaifa/2637.html