用CASE WHEN.
SELECT Field1 ,Field2 ,CASE WHEN Field3 IS NULL THEN ... WHEN Field3 = 'A' THEN ... WHEN Field3 = 'B' THEN ... WHEN Field3 = 'C' THEN ... END AS Field3INTO #TempFROM table1
