SQL语言的CASE语句备忘

hyzqb

case var1　　when '01' then values 'A' into var2;
　　when '02' then values 'B' into var2;
　　when '03' then values 'C' into var2;
　　when '04' then values 'D' into var2;
　　when '05' then values 'E' into var2;
　　when '06' then values 'F' into var2;
　　when '07' then values 'G' into var2;
　　when '08' then values 'H' into var2;
　　when '09' then values 'I' into var2;
　　when '10' then values 'J' into var2;
　　when '11' then values 'K' into var2;
　　when '12' then values 'L' into var2;
　　when '13' then values 'M' into var2;
　　when '14' then values 'N' into var2;
　　when '15' then values 'O' into var2;
　　when '16' then values 'P' into var2;
　　when '17' then values 'Q' into var2;
　　when '18' then values 'R' into var2;
　　end case;