Receiving error message: Error converting data type nvarchar to float.
Posted on 2006-11-16
I have a .NET application (SQL Server backend). I am using a SQL statement to retrieve data and then display it on my web page.
I'm working with a field that is nvarchar. I need to be able to display an N/A when there is no data for that particular field. Here's the portion of the SQL Statement that I have so far:
ISNULL(pmoApps.dbo.ss_PDMMAST.acthours, N'N/A') as SEHours
When I run it, I'm receiving the error: Error converting data type nvarchar to float. What do I need to add to it to make it display N/A.