Re: SQL-LOADER problem (VARCHAR2)

Presumably you want to trim off the trailing spaces during load. To do this, SQL*Loader allows you to attach an SQL "phrase" to each column which can utilize the full range of ORACLE's SQL Functions, like Ltrim,Rtrim,Substr, etc.

E.g. field1 pos(*) char(5) "RTRIM(:field1)",

You can use and string together any/all of the SQL functions provided by ORACLE to alter the data.

Regards
Tony

Tony Bravo                                         71001.1253_at_compuserve.com