【搞定】2617版本sql不支持case语句

aDragon

像这样得语句
  SELECT top 1000 HT_CWINFO.*,(CASE WHEN htcwproperty='收费' THEN htcwCharge ELSE 0 END) as sf, (CASE WHEN htcwproperty='付费' THEN htcwCharge ELSE 0 END) as ff
  FROM HT_CWINFO, HT_REPOPARA
  WHERE (HT_CWINFO.HTGROUPID = HT_REPOPARA.HTCWGROUPID) and (HT_CWINFO.HTCWDATE <= HT_REPOPARA.HTCWDATE) and ( HT_CWINFO.HTCWNEXTFLAG='1')
  ORDER BY HT_CWINFO.HTCWDAT

2110版本是支持得，而2617版本不支持了！如何处理？

aDragon

这个问题已经通过表达式计算字段解决了！