Also, TO_DATE() should have a secodn parameter I think. To_Date('01.01.2000', 'DD.MM.YYYY') Shanx --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.265 / Virus Database: 137 - Release Date: 18-Jul-01