case OrderDate when OrderDate between '1999-1-1' and '2005-12-31' then 8.3 ？？
case 里是否可以用 between and ？？ 用between and 是 ok 的 冇问题啦
只是这语法不对，应该这样写:
case when OrderDate between '1999-1-1' and '2005-12-31' then 8.3 end ......记得 End