Case Statement using Microsoft Access ODBC Driver

[tonyweis]

I am trying to use a case like the following in a query to a microsoft Access database but it tells me i have a missing operator in the case expression. I have tried to rework the case statement a million ways and it still gives me the same error.

select nm = case when c.deliveryname = '' then c.name else c.deliveryname end

Any ideas?

 

[SkipVought]

Hi,

If you're using the Access ODBC Driver, the CASE statement is not part of the SQL language. You'd have to use the IIF() function.

BTW, I've never seen ...

Select [b]n =[/b] m

Using the CASE statement...

select case when c.deliveryname = '' then c.name else c.deliveryname end

or am I missing something???



Skip,

_[red][/red]