LearnUp: 那就是这个意思? [阅读: 351] 2008-04-10 08:11:11 Select *,X= CASE WHEN Y=0 THEN 0 WHEN Y=1 THEN 1 ELSE 2 END From A Where (Y=0) or (Y=1)