1 select   isnull(b.py,upper(left(a.name,1)))     as   py  
 2   ,a.name  
 3   from   province
 4   a  
 5   left   outer   join   (  
 6   select   ‘A‘   as   PY,N‘驁‘   as   word,   N‘啊‘   as   sword  
 7   union   select   ‘B‘,N‘簿‘,N‘驁‘  
 8   union   select   ‘C‘,N‘錯‘,N‘簿‘  
 9   union   select   ‘D‘,N‘鵽‘,N‘錯‘  
10   union   select   ‘E‘,N‘樲‘,N‘鵽‘  
11   union   select   ‘F‘,N‘鰒‘,N‘樲‘  
12   union   select   ‘G‘,N‘腂‘,N‘鰒‘  
13   union   select   ‘H‘,N‘夻‘,N‘腂‘  
14   union   select   ‘J‘,N‘攈‘,N‘夻‘  
15   union   select   ‘K‘,N‘穒‘,N‘攈‘  
16   union   select   ‘L‘,N‘鱳‘,N‘穒‘  
17   union   select   ‘M‘,N‘旀‘,N‘鱳‘  
18   union   select   ‘N‘,N‘桛‘,N‘旀‘  
19   union   select   ‘O‘,N‘漚‘,N‘桛‘  
20   union   select   ‘P‘,N‘曝‘,N‘漚‘  
21   union   select   ‘Q‘,N‘囕‘,N‘曝‘  
22   union   select   ‘R‘,N‘鶸‘,N‘囕‘  
23   union   select   ‘S‘,N‘蜶‘,N‘鶸‘  
24   union   select   ‘T‘,N‘籜‘,N‘蜶‘  
25   union   select   ‘W‘,N‘鶩‘,N‘籜‘  
26   union   select   ‘X‘,N‘鑂‘,N‘鶩‘  
27   union   select   ‘Y‘,N‘韻‘,N‘鑂‘  
28   union   select   ‘Z‘,N‘咗‘,N‘韻‘  
29   )   b   on   left(name,1)   between   b.sword   and   b.word order by name