A count is not a SUM. SUM should be tested for failure for the specific case of a numeric column altered to VARCHAR. It should succeed as long as the summed column remains a summable type.