To pengdali(大力 V2.0): where ClassCode like case ClassCode when '01' then '%' else '02' end 不完全符合我的意思: 我的意思:当ClassCode='01'时则为ClassCode like '%',其余的则为:ClassCode='02'
where ClassCode like case ClassCode when '01' then '%' else '02' end 或: where case ClassCode when '01' then ClassCode like '%' else ClassCode ='02' end
like '02' 与 ='02' 的结果是一样的.
select ......... where case ClassCode when '01' then ClassCode like '%' else ClassCode ='02' end
where ClassCode like case ClassCode when '01' then '%' else '02' end 不完全符合我的意思:
我的意思:当ClassCode='01'时则为ClassCode like '%',其余的则为:ClassCode='02'
或:
where case ClassCode when '01' then ClassCode like '%' else ClassCode ='02' end