Re: Does Informix Provide Poor Product support ???

Ok so you are skeptical. Try code the following statements in Informix. I use SE v5.00, but I don't think you can do any more in On-Line. Have fun... SELECT ( TO_DATE(:1)-TO_DATE(:2) ) / 365.25 FROM DUAL; // dual is a dummy table with one row that we use for doing // these kinds of select statements (ie using SQL for // date arithmetic, etc) SELECT TRANS_TYPE, TRANS_DATE, REPORT_SECTION, CURRENCY, UKL_VALUE + NVL(VAT_VALUE, 0), CURRENCY_VALUE + NVL(VAT_VALUE, 0), OS_VALUE, NVL(BAD_DEBT_VALUE, 0), NVL(VAT_VALUE, 0), ROWID, ROUND( ( DECODE(UKL_VALUE,0,1,NULL,1,UKL_VALUE ) / DECODE(CURRENCY_VALUE,0,1,NULL,1,CURRENCY_VALUE) ) * OS_VALUE, 2),DESCRIPTION FROM SALES_LEDGER_ITEM WHERE REFERENCE = :1 AND SALES_ACCOUNT = :2 AND NVL(OS_VALUE, 0) != 0 AND STATUS IN('PD','AU'); -- David H Lipschitz email: david@lipdav.demon.co.uk If you don't try, you won't know