<div>
what is the datatype of your VALUE field?<br />

</div>


<div>
data type of value field is int
</div>


<div>
On the scorecard how do i display as 'n/a' where there is no value.<br />
I want to only display and not update
</div>


<div>
select isnull(value, 'N/A')<br />
from #Scorecard<br />

</div>


<div>
<div class="content wysiwyg-content">
SqlServer<br />
update &nbsp; #Scorecard<br />
set value = 'N/A' where value = ' '<br />
<br />
This gives Error --<br />
Error converting data type varchar to numeric.<br />
pls someone give me a solution<br />

</div>
</div>


SqlServer
update   #Scorecard
set value = 'N/A' where value = ' '

This gives Error --
Error converting data type varchar to numeric.
pls someone give me a solution


what is the datatype of your VALUE field?


On the scorecard how do i display as &amp;#39;n/a&amp;#39; where there is no value.
I want to only display and not update

select isnull(value, &amp;#39;N/A&amp;#39;)
from #Scorecard


data type conversion

SqlServer
update   #Scorecard
set value = &amp;#39;N/A&amp;#39; where value = &amp;#39; &amp;#39;

This gives Error --
Error converting data type varchar to numeric.
pls someone give me a solution


Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.