IIF Syntax

[DanNorris2000]

What comma did I miss in the IFF expression?

sum(Ledger.osexp + ledger.osloss)AS totalos,;
IIF((substr(clms.claimant,1,3)<>&quot;AGG&quot,&quot;AGG&quot; as clmtprefix;
FROM mrcdata!clms left outer JOIN mrcdata!Ledger;

Program error : Missing comma(,)

 

[Mike Gagnon]

DanNorris

There sould be another possibility for the IIF statement, its usually &quot;if this = that then use this, ortherwise use this&quot;. So in your case :
IIF((substr(clms.claimant,1,3)<>&quot;AGG&quot;,&quot;AGG&quot;,&quot;BHH&quot && Or whatever the alternate option is.


Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[DanNorris2000]

worked great thanks