<div>
Note: if there are any non-numeric characters in this field, you will get an error. You really need to move towards storing your data in the correct type.
</div>


Note: if there are any non-numeric characters in this field, you will get an error. You really need to move towards storing your data in the correct type.

<div>
I understand this, but this has gone live already and there is not much of a choice, plus this is just a pilot project...<br />
turns out...int wont work because there are decimal values....<br />
so change I just int to decimal and it will be good?
</div>


I understand this, but this has gone live already and there is not much of a choice, plus this is just a pilot project...
turns out...int wont work because there are decimal values....
so change I just int to decimal and it will be good?

<div>
<div class="content wysiwyg-content">
I have a table that is labeled as a nvarchar and it contains only numbers, I want to do a query like below (sum) but I get error because its a nvarchar field.<br />
<br />
select sum(startingbid) as totalvaue from items<br />
<br />
The sum or average aggregate operation cannot take a nvarchar data type as an argument.<br />
<br />
changing the column to an int is not an option...
</div>
</div>


I have a table that is labeled as a nvarchar and it contains only numbers, I want to do a query like below (sum) but I get error because its a nvarchar field.

select sum(startingbid) as totalvaue from items

The sum or average aggregate operation cannot take a nvarchar data type as an argument.

changing the column to an int is not an option...

sql sum on nvarchar 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.