How do I write a CASE statement in BDE Local SQL
Posted on 2008-06-11
I'm trying to get Database Tour to run a CASE statement like
WHEN sum(invdtl.linetot) = 0 then '"G0"
WHEN sum(invdtl.linetot) between 1 and 1000 then '"G999"
WHEN sum(invdtl.linetot) between 1000 and 2000 then '"G1999"
End Case as 'GROUPCODE'
I get an error saying
"Invalid use of Keyword
I gather "CASE" is not supported in the BDE implementation of local SQL
How should I write this now?