SQL Help 1

[Swi]

Does anyone have any ideas about what is wrong with the following SQL statement. I am attempting to create a query but it keeps bombing out:

select case when Column = 1 then 0 else 1 end
from Table

Error:
Syntax error (missing operator) in query expression 'case when Column = 1 then 0 else 1 end'.

Swi

 

[PHV]

select IIf(Column = 1, 0, 1)
from Table

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Swi]

Thanks. Works like a charm. Do you know why the case statement is not working?

Swi

 

[PHV]

Because JetSQL is far away from ANSI compliance ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Swi]

Thanks.

Swi