Hello,

I do most of my programming via MS-Access/VBA SQL2000.

I've migrated to SQL 2005 and would like to utilise SQL for more of my calc work.
I run into problems when trying to SUM values via a View, where some values = NULL.
In Access i'd write an IIF expression in a query to convert NULL values to 0 for calculation purposes.

Can somebody please advise how to perform this via SQL 2005.

Thankyou,

Dave

You'll love this:

    ISNULL( fieldname, 0 )

Yep. Really.

Does the same thing as

    IIF( fieldname IS NULL, 0, fieldname )

in Access.

Thank you very very much.

Dave