Hi,

> > A quick remark: stop using those double quotes around
> > object names! It makes them case sensitive!!
>
> I want to make them case sensitive!!! :)

Why??

> My question is how can I port this SQL statement from MSSQL to
> Firebird:
>
> (case
> when isnull(EC_UsrID, 0) <> 0 then EC_UsrTS
> when isnull(KV_UsrID, 0) <> 0 then KV_UsrTS
> when isnull(OE_UsrID, 0) <> 0 then OE_UsrTS
> when isnull(MD_UsrID, 0) <> 0 then MD_UsrTS
> else 0 end) as StatusTS
>
> Does someone know how?

Ask Arno, he implemented "CASE".

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com