You can't unless you make conversion. Note: It's not possible to convert entire data into numeric value. That's why conversion could failed.
Please, see:
CAST and CONVERT (T-SQL)[
^]
By The Way: If yoou store numeric data as a varchar, it means: bad table design. I would recommend you to re-design your table.