Hi,

> > (CASE
> > WHEN COALESCE(EC_UsrID, 0) <> 0 THEN EC_UsrTS
> > WHEN COALESCE(KV_UsrID, 0) <> 0 THEN KV_UsrTS
> > WHEN COALESCE(OE_UsrID, 0) <> 0 THEN OE_UsrTS
> > WHEN COALESCE(MD_UsrID, 0) <> 0 THEN MD_UsrTS
> > ELSE 0
> > END) as StatusTS
> >
> I have tried that, but I allways get error:
>
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Datatypes are not comparable in expression CASE.
>
> What to do?
> Any other SQL construction can give me the same result?

Could you give me only the necessary metadata to reproduce this?
What datatypes do the fields EC_UsrID, KV_UsrID, OE_UsrID and MD_UsrID have?

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81