I am trying to add 1 to a fieldvalu

[redtoad]

I am trying to add 1 to a fieldvalue. This works great except when a null value is returned. How do I set a null value to 0? I tried using the ISNULL function but kept getting a null value returned.


Select top 1 num.fieldvalue + 1 as 'num.fieldvalue'
FROM blah blah blah


Thanks.

 

[JohnDTampaBay]

Try something like this:

SELECT TOP 1 IsNull(num.fieldvalue,-1) + 1 AS 'num.fieldvalue' FROM blah blah blah

--Angel
-----------------------------------
SELECT * FROM users WHERE clue > 0
0 row(s) selected

 

[redtoad]

Actually, the issue is, and I didn't metion this before, that there is no row given the constraints. I need to insert a row with num.fieldvalue of 1 if there is no row. So I think I will be able to do that by evaluating the query, then inserting a row if none is returned.

Thanks for your help.