Hi,

Is there any other way to use conditions for field selection in a select query beside
coalesce? I remember seeing such example somewhere in the forums, but cannot find it and
there is no sign of it in the documentation either, so I must be wrong.

I mean something  like:

Select  
iif(Field1>1, Field1, Field2 ) as Field4
from ...

or

Select  
case
 when Field1>1 ...
from ...

Regards,
Leslie

Lelsie

> Is there any other way to use conditions for field selection in a select
query beside
> coalesce? I remember seeing such example somewhere in the forums, but
cannot find it and
> there is no sign of it in the documentation either, so I must be wrong.
>
> I mean something  like:
>
> Select
> iif(Field1>1, Field1, Field2 ) as Field4
> from ...

Check out the following link for the "If" systax.

http://www.elevatesoft.com/manual?action=mantopic&id=edb2sql&category=13&topic=225

John

Lelsie


I don't know about CASE but you were almost there with iif

Here's a couple of examples

IF(J._MainPhone IS NOT NULL  THEN J._MainPhone
ELSE  Site._Switchboard) AS _MainPhone,

IFNULL(W._LatestCV THEN FALSE ELSE TRUE) AS _HasCV


Roy Lambert [Team Elevate]

John & Roy,

Thank you very much for the quick help.

Leslie

Leslie,

<< I mean something  like:

Select
iif(Field1>1, Field1, Field2 ) as Field4
from ...

or

Select
case
 when Field1>1 ...
from ... >>

Yes, you can use either syntax.  Just change the IIF() to IF().

--
Tim Young
Elevate Software
www.elevatesoft.com