If it's not fixed-width, just write a tiny program to pad it to fixed
width and then use an external table with a char(n) column.

In your SQL, trim the value from the external table and cast if required.

Kjell

Milan Babuskov wrote:

>
>
> Myles Wakeham wrote:
> > It’s a single column of data
>
> Is it fixed-width? If yes, using an external table is the fastest way.
>
> --
> Milan Babuskov
> http://www.flamerobin.org <http://www.flamerobin.org>
> http://www.guacosoft.com <http://www.guacosoft.com>
>
>

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64