SQLLDR

        Lets say I have the following load.ctl file:

load data
infile 'MyData.DAT'
append into table MyTable
fields termilated by ',' optionally enclosed in '"' (Field1,Field2,Field3)

        The Field widths are 10,10,10, respectivly of char.

        The data looks like:

"Some Data","This Data2 is too long!","Some Data"
"My Data","This Data is too long too!","Data"
"Data","Ok Data","Nice Data"

        How can I truncate the 2ed piece of data to ensure that is is only 10 long and will fit in Field2?

        I can't figure out how to use the Position statement because the positions vary from line to line.         

        Any help will be... helpful! :)

	Brit willoughby
        Brit.Willoughby_at_WICHITAKS.ATTGIS.COM




        Brit Willoughby
        Brit.Willoughby_at_WichitaKS.ATTGIS.Com