Re: date - import

Hello,

The data 00.00.0000 is an invalid date, you could translate this NULL on the load by using the NULLIF clause

i.e

NULLIF indate = '00.00.0000'

Boogie

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