isNumeric returns True (1) when the string can be converted into a number.

'1111D1' can be converted into a number 1111 - D for decimal

'11E2' can also be converted into a number 1100 - E for exponent (power of 10).

If you need to check that the string only contains numerics then you will need a different piece of code e.g patindex

Jez