Re: SQL*Loader

[question about parsing a field into up to 3 fields as date components]

As SQL*Loader can contain PL/SQL you could set up a series of when clauses and parse the date based on it's length and other factors which will tell you when it's got a year or not. Clearly this will be rather tricky as you'll need lots of rules. Look at the Utilities manual.

hth,

gary         -=-  The C Programmers' Reference -=-
        http://users.southeast.net/~garyg/C_ref/C/c.html
        -=-    Avenue Programmers' Classes' Requests -=-
         http://users.southeast.net/~garyg/classes.htm