SQL*Loader and Implied decimals

Hello all...

I have a flat file that I am trying to import via SQL*Loader. In this file there are two fields that contain decimals, but the actual decimal is not in the datafile itself.

For example I am importing data that is 3 columns in lenght including one decimal place (3,1). So it should look like 12.3, but the file has it as 123! How do I tell Loader to expect xxx and turn that into xx.x?

Thanks,
--Jay
Jay Barbee
jybarb01!@homer.louisville.edu
[ANTISPAM, remove "!" from address above...] Received on Mon Apr 27 1998 - 10:35:17 CDT