• At the moment, I would doubt that all the data coming in adheres to your specified format.  Run something like the following:

    SELECT * FROM tableA WHERE ISNULL (FieldNameA, '') NOT LIKE REPLICATE ('[0-9]', LEN (FieldNameA))

    My guess is that you'll come up with at least one value that is not in the expected format.