Using a CASE statement in another spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I'm selecting from another spreadsheet via ODBC, and want to use a CASE
function in the select statement, to short cut some summing up.

Is something like this possible (heres a cut down version)?
SELECT ActualApr05, case when ActualApr05 <>0 then ActualApr05 else 0 end as
QT105 FROM forecastcosts

The statement above returns the following error:
[Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query
expression 'case when ActualApr05 <>0 then ActualApr05 else 0 end'.

Any ideas?
Many thanks in advance
 
...
replace the Case statement by an IIF statement, eg:
SELECT
ActualApr05,
iif( ActualApr05 <>0, ActualApr05, 0) as QT105
FROM forecastcosts
Click to expand...

I can't see the CASE statement is needed e.g. apart from being less
efficient, how is it different from

SELECT
ActualApr05, ActualApr05 AS QT105
FROM forecastcosts

?

Jamie.

--
 
Back
Top