Hi NG,

are this actually valid expressions for DB2 v 7.2?

SELECT TABLE.ATTR1
FROM TABLE
WHERE
CURRENT DATE - 1 MONTH <= LAST_DAY(TABLE.ATTR2)

and

SELECT TABLE.ATTR1
FROM TABLE
WHERE
TABLE.ATTR2 <= TABLE.ATTR3

- ATTR2 and ATTR3 are DATE-columns...

Appreciate everyones help!!!

Thanks in Advance,

S.B.