SELECT MONTH(date) AS m_date, YEAR(date) AS y_date,;
     SUM( IIF( payer=nAN, -summa, 0)) AS expense,;
     SUM( IIF( recipient=nAN, summa, 0)) AS incoming;
     FROM bank_oper;
     GROUP BY y_date, m_date;
    INTO CURSOR by_month_s09

[code]SELECT MONTH(date) AS m_date, YEAR(date) AS y_date,;
     SUM( IIF( payer=nAN, -summa, 0))+0.01 AS expense,;
     SUM( IIF( recipient=nAN, summa, 0))+0.01 AS incoming;
     FROM bank_oper;
     GROUP BY y_date, m_date;
    INTO CURSOR by_month_s09

SELECT MONTH(date) AS m_date, YEAR(date) AS y_date,;
     SUM( IIF( payer=nAN, -summa, 000000000000.00)) AS expense,;
     SUM( IIF( recipient=nAN, summa, 000000000000.00)) AS incoming;
     FROM bank_oper;
     GROUP BY y_date, m_date;
    INTO CURSOR by_month_s09

SELECT MONTH(date) AS m_date, YEAR(date) AS y_date,;
     cast(SUM( IIF( payer=nAN, -summa, 0)) as N(12,2)) AS expense,;
     cast(SUM( IIF( recipient=nAN, summa, 0)) as N(12, 2)) AS incoming;
     FROM bank_oper;
     GROUP BY y_date, m_date;
    INTO CURSOR by_month_s09

SELECT MONTH(date) AS m_date, YEAR(date) AS y_date,;
     SUM( IIF( payer=nAN, cast(-summa as N(12,2)), cast(0 as N(12,2)))) AS expense,;
     SUM( IIF( payer=nAN, cast(summa as N(12,2)), cast(0 as N(12,2)))) AS incoming;
     FROM bank_oper;
     GROUP BY y_date, m_date;
    INTO CURSOR by_month_s09

CREATE CURSOR curs1 (field1 N(5,2))
INSERT INTO curs1 VALUES (1)
INSERT INTO curs1 VALUES (1.29)

* без CAST()
CREATE CURSOR curs2 (field1 N(5,2))
INSERT INTO curs2 SELECT SUM(IIF(field1=1,1,field1)) as field1 FROM curs1
SELECT curs2
BROWSE FIELDS field1 :H='без CAST'

* с CAST()
CREATE CURSOR curs2 (field1 N(5,2))
INSERT INTO curs2 SELECT SUM(CAST(IIF(field1=1,1,field1) as N(5,2))) as field1 FROM curs1
SELECT curs2
BROWSE FIELDS field1 :H='с CAST'

* снова без CAST()
CREATE CURSOR curs2 (field1 N(5,2))
INSERT INTO curs2 SELECT SUM(IIF(field1=1,1,field1)) FROM curs1 as field1
SELECT curs2
BROWSE FIELDS field1 :H='без CAST'