I tried with DECODE function and it's working. Thanks On 8/10/05, Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote: > > Is it not Easier to do this via sed ??? > > On 10/08/05, VuCanDo <vuquyen@xxxxxxxxx> wrote: > > Is there any ways that we can use SQL*Loader to load NULL value when see > bad > > dates like 0000000 into date column? > > > > Thanks, > > > > Vu > >