Alan,

> The CASE statement itself works in an Sql editor window as per:-
> select
> weigh_code,
> tonnes,
> case when (tonnes<20) then 'light' when (tonnes>20) then 'heavy' end
> from weigh
> 345 19.78 light
> 378 22.56 heavy
> ...

FYI, do you realize that you're not handling the case where tonnes = 20?


Sean