Checking for NULL Values

Checking for NULL Values

When you read a string from a character field in a snapshot/dynaset you can append a pair of double quotes to protect yourself from “Type mismatch” errors, if the field was to actually null.Is there a way to do the same thing with numeric fields in any way?

Unfortunately, there isn’t. Many times, a null value is significantly different than a zero value, so you can’t do that. I just check IsNull before I try to do something with it. However, I try to avoid allowing null values, just as a practice. Your database can also be set up to prevent Null values in the first place, if that’s appropriate for your situation.


Share the Post: