[MSSQL]取汉字首字母的两个函数

go
--创建取汉字首字母函数(第一版)
create function [dbo].[f_getpy_V1] (@str nvarchar(4000)) 
returns nvarchar(4000) 
as
begin 
declare @word nchar(1),@py nvarchar(4000) 
set @py='' 
while len(@str)>0 
begin 
set @word=left(@str,1) 
set @py = @py+ (case when unicode(@word) between 19968 and 19968+20901 
then ( 
select top 1 py 
from 
( 
select 'a' as py, N'驁' as word 
union all select 'B',N'簿' 
union all select 'C',N'錯' 
union all select 'D',N'鵽' 
union all select 'E',N'樲' 
union all select 'F',N'鰒' 
union all select 'G',N'腂' 
union all select 'H',N'夻' 
union all select 'J',N'攈' 
union all select 'K',N'穒' 
union all select 'L',N'鱳' 
union all select 'M',N'旀' 
union all select 'N&