apply proper validation to datatype conversion of numeric types