Re: Select Statement
From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 24 May 2008 14:49:51 +0200
Message-ID: <ebe1$48380ef0$524b5c40$10094@cache6.tilbu1.nb.home.nl>
Date: Sat, 24 May 2008 14:49:51 +0200
Message-ID: <ebe1$48380ef0$524b5c40$10094@cache6.tilbu1.nb.home.nl>
Shakespeare wrote:
> -select case
> - when greatest(a,b,c)=-99999 then -99999
> - when least(a,b,c)=-99999 then 0
> - else a+b-c
> - end calc
> - from table
>
"end calC" should be end caSE, I presume
-- Regards, Frank van BortelReceived on Sat May 24 2008 - 07:49:51 CDT