True, SQLLOADER has syntax for such manipulations - WHEN, NULLIF, DEFAULTIF: http://docs.oracle.com/cd/E16655_01/server.121/e17639/ldr_field_list.htm#SUTIL1202 And apparently external tables also have at least NULLIF (even though external tables do have less such flexibility than sqlloader): http://docs.oracle.com/cd/E16655_01/server.121/e17639/et_params.htm#SUTIL4224 But that seems to be a 12c addition to external tables - at least I can't find it in 11.2 docs. And OP needs a solution that works in version 9.2, alas ;-) Regards Kim Berg Hansen http://dspsd.blogspot.com kibeha@xxxxxxxxx @kibeha On Thu, Jan 30, 2014 at 4:31 PM, Fergal Taheny <ftaheny@xxxxxxxxx> wrote: > Hi Chris, > > This is taken from an 11g sqlloader control file. Haven't tried this with > an external table but I think it should work: > > APPLICATION_DATE POSITION (203:210) DATE(8) "YYYYMMDD" nullif > application_date = '00000000' > > Regards, > Fergal >