Sean
Yes
that was just a sample showing that the CASE tatement itself works. The
real problem was in the SP
Alan

> 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
>
>
>
> ------------------------ Yahoo! Groups Sponsor --------------------~--
>
> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------------~-
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>

Alan J Davies
Tel: +44 (0)1926 842069
Fax: +44 (0)1926 843755