Rewrite Query

[ielamrani]

Hi,
is there a way to rewrite this code to make it short. The query won't run
because it max the # of characters allowed. sorry it's written in caps.
thanks in advance:

BASE ADMIN: IIf(CDPINC_ARIBD!IDACCTREV="5021-0PENSN-QTV" Or CDPINC_ARIBD!
IDACCTREV="5021-0PENSN-SAV" Or CDPINC_ARIBD!IDACCTREV="5021-0PENSN-ANV" Or
CDPINC_ARIBD!IDACCTREV="5021-0PENSN-RSA" Or CDPINC_ARIBD!IDACCTREV="5021-
0PENSN-PER" Or CDPINC_ARIBD!IDACCTREV="5021-0PENSN-DOC" Or CDPINC_ARIBD!
IDACCTREV="5021-0PENSN-SDI" Or CDPINC_ARIBD!IDACCTREV="5021-0PENSN-SVC" Or
CDPINC_ARIBD!IDACCTREV="5020-0PENSN-QTV" Or CDPINC_ARIBD!IDACCTREV="5020-
0PENSN-STQ" Or CDPINC_ARIBD!IDACCTREV="5020-0PENSN-MSC" Or CDPINC_ARIBD!
IDACCTREV="5020-0PENSN-PER" Or CDPINC_ARIBD!IDACCTREV="5020-0PENSN-DOC" Or
CDPINC_ARIBD!IDACCTREV="5020-0PENSN-SDI" Or CDPINC_ARIBD!IDACCTREV="5020-
0PENSN-SVC",CDPINC_ARIBD!AMTTXBL,0)

[NeoPa]

Use the In() structure :
[CODE=SQL]BASE ADMIN: IIf(CDPINC_ARIB D.IDACCTREV In('5021-0PENSN-QTV','5021-0PENSN-SAV','5021-0PENSN-ANV','5021-0PENSN-RSA','5021-0PENSN-PER','5021-0PENSN-DOC','5021-0PENSN-SDI','5021-0PENSN-SVC','5020-0PENSN-QTV','5020-0PENSN-STQ','5020-0PENSN-MSC','5020-0PENSN-PER','5020-0PENSN-DOC','5020-0PENSN-SDI','5020-0PENSN-SVC'),CDPINC_AR IBD.AMTTXBL,0)[/CODE]