How to manage NULL values with numeric fields in cursor?

sql-server, stored-procedures

Solution

Don't use cursors.

If you must (really?), you can use the ISNULL function:

SELECT ISNULL(fieldname, 0)

will give you a "0" (zero) instead of NULL.

Problem

How to manage NULL values in numeric fields returned by cursor in Select stament, to manage efficienly aritmetic operations ?

Original source