Re: Please can anyone help me with SQL in Oracle.

Ray,

I think that you will have to use a trigger to catch such date range errors during inserts or updates.

Rock.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!