CASE syntax?

[milton747]

I wrestling with the CASE statement below.
I want to set FLAGC based on credit rank and order total.
See anything odd? Thanks folks.



SELECT customers.creditrank, OrderTotals.OrderTotal,
CASE ( WHEN OrderTotals_OrderTotal > 1000000 AND customers_creditrank = 'A' THEN '1'
END) AS FLAGC
FROM customers, OrderTotals

 

[PHV]

JetSQL use IIf instead of CASE:
IIf(condtion, true value, false value)

The above is the translation of the below:
CASE WHEN condtion THEN true value ELSE false value END

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886