Only if the datatype of the fields is CHAR(), not a VARCHAR2(). Which is not so likely.

:confused:

04-28-2003, 06:55 PM

slimdave

The problem with this methodology in your case is not the data type, but the fact that the data is delimited and quoted -- otherwise you could specify CHAR in the control file reference and data loaded to an underlying varchar2 filed would get trimmed.

In your case you will have to apply a SQL operator to the field, as in the other doc link.