>ISNUMERIC function can give you false positives.
For real? Can you describe in which occasions this may happen? In my test, I have a record containing mi5 in the record. I would still like to have the record to be imported in the new table but to have a 0 value in the new table numeric field. I would then believe that just using ISNUMERIC() wouldn't enough for that request. At first, I thought that I could use a syntax in the field level list so to have all the records but to convert into numeric, without receiving the error. Is that possible?
>If you want to filter all non-numbers, use
>
>WHERE Column NOT LIKE '%[^0-9]%'
Thanks
