Re: SQl Load question about decimal comma is point

Preprocess the data using perl, awk, etc. or use a preinsert trigger to massage the input.

Monique van Daal wrote:
>
> We want to load a file with amounts.
> In the external file the amount are define as 999999,99 in stead of
> 999999.99 (look at the comma and the point as decimal)
> How can we translate in SQLload the comma to a point?
>
> thanks in advance

--
ÐÏࡱá Received on Wed Jun 30 1999 - 12:26:22 CDT