Checking for NULL Values

Question:
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?

Answer:
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:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: