sriramb69
asked on
data type conversion
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
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
data type of value field is int
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
On the scorecard how do i display as 'n/a' where there is no value.
I want to only display and not update
I want to only display and not update
select isnull(value, 'N/A')
from #Scorecard
from #Scorecard
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.