Hi.

>
> A quick remark: stop using those double quotes around
> object names! It makes them case sensitive!!

I want to make them case sensitive!!! :)

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?

> With regards,
>
> Martijn Tonies

Best regards
Fikret Hasovic
TAMP R&D Team