1 CREATE function f_GetFirstPy(@str varchar(50)='')
2 returns char(1)
3 as
4 begin
5 declare @n int, @c char(1), @chn nchar(1)
6 select @n=63, @chn=substring(@str,1,1)
7 if @chn > 'z'
8 if( @chn < '八' ) set @c = 'A'
9 else if ( @chn < '嚓' ) set @c = 'B'
10 else if ( @chn < '咑' ) set @c = 'C'
11 else if ( @chn < '妸' ) set @c = 'D'
12 else if ( @chn < '发' ) set @c = 'E'
13 else if ( @chn < '旮' ) set @c = 'F'
14 else if ( @chn < '铪' ) set @c = 'G'
15 else if ( @chn < '丌' ) set @c = 'H'
16 else if ( @chn < '丌' ) set @c = 'I'
17 else if ( @chn < '咔' ) set @c = 'J'
18 else if ( @chn < '垃' ) set @c = 'K'
19 else if ( @chn < '嘸' ) set @c = 'L'
20 else if ( @chn < '拏' ) set @c = 'M'
21 else if ( @chn < '噢' ) set @c = 'N'
22 else if ( @chn < '妑' ) set @c = 'O'
23 else if ( @chn < '七' ) set @c = 'P'
24 else if ( @chn < '呥' ) set @c = 'Q'
25 else if ( @chn < '仨' ) set @c = 'R'
26 else if ( @chn < '他' ) set @c = 'S'
27 else if ( @chn < '屲' ) set @c = 'T'
28 else if ( @chn < '屲' ) set @c = 'U'
29 else if ( @chn < '屲' ) set @c = 'V'
30 else if ( @chn < '夕' ) set @c = 'W'
31 else if ( @chn < '丫' ) set @c = 'X'
32 else if ( @chn < '帀' ) set @c = 'Y'
33 else set @c = 'Z'
34 else if @chn <= 'z' and @chn >= 'a'
35 set @c = upper(@chn)
36 else if @chn <= 'Z' and @chn >= 'A'
37 set @c = @chn
38 else
39 set @c = ''
40 return (@c)
41 end