Try:

SELECT

30.AString

,50.E-3AnotherString

,10.E0SomethingElse

into dbo.TempTable;

select * from dbo.TempTable;

You can see that SQL try to parse the number till the not numeric character and then take...

My solution was to loop the files (directory), copy (move) the file to fix temp directory and fix name, do the job, move (delete) the file to archive directory.

Izhar Azati

The 5 lines can by also in the middle of the file!!