I am reading the data from the file using the proper offsets, loading the data into an array, only the data i require, then using a loop function i am creating a bulk insert in to sql table. then it does the insert. Just was not sure if there was some sort of function i could add into the insert line that would check the data and if any thing other than numeric eliminate it and change it to zeros.
so lets say the data which is normally numeric is 0006345, with the new features of the program that creates the file it could be LE06345 or it could be 0LE6345, it would depend on the user of the software set it up. But these alpha characters are not there all the time, or at least not now can not say in the future it wont change. So if i can find a way to fix it now then i need not worry in the future as they change their software.
I mean i could change the offsets so that the first 3 characters are not read into the array but if i did that and then the number in that field went above 9999 then i would not have the right numbers.
Hope that is clear.