<div>
SELECT SUM(CAST (varcharColumn as integer )) -- you can cast it as integer or numeric (10,2) depending on the values stored<br />
WHERE ISNUMERIC(varcharColumn) =1 
</div>


SELECT SUM(CAST (varcharColumn as integer )) -- you can cast it as integer or numeric (10,2) depending on the values stored
WHERE ISNUMERIC(varcharColumn) =1

<div>
Now , if it stores a numeric field always, they ehy you keep it as a varchar column ? 
</div>


Now , if it stores a numeric field always, they ehy you keep it as a varchar column ?

<div>
select sum(cast(fieldName as int)) from tableA<br />
<br />
Will find the sum (assumin that the numbers you have are integers)
</div>


select sum(cast(fieldName as int)) from tableA

Will find the sum (assumin that the numbers you have are integers)

<div>
<div class="content wysiwyg-content">
How to I perform a sum on a varchar field that always contains numeric content?
</div>
</div>


How to I perform a sum on a varchar field that always contains numeric content?

Sum of a VarChar Field

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.