>Dear Experts,
>
>I m getting "Numeric Overflow data was lost" error while i m doing mathmatical operations in a field Values, this is due to
>non numeric charectors(*******.**)due to insufficent filed length during upation.So, is there anyway to check the charector type for
>such special charectors.
>I Used IsDigit function, but no result
>
Abdulla,
If you want to use the ISDIGIT() function, you'll have to check each character of the string.
George
Ubi caritas et amor, deus ibi est