Agree with SASLOVIMe.
If _COL3 is just quoted numbers, such as ’12.33’, there should be no problem of reading into numeric (truncated for the first 8 letters). If mixed with letters, such as ‘A123’, the result is missing.
If you really want to solve the problem, you should present some example values of _COL3.