The Industry Insiders

Insight from the heart of the IT industry

Testing for Database Null Values from PowerShell

Testing for Database Null Values from PowerShell

  • Comments 1
  • Likes

PowerShell is super, but its documentation is still lousy. You might think that how to test a database field for a null value would be straightforward, and indeed it is, but it ain’t documented anywhere. I’ve just spent the afternoon searching and eventually had to work it out for myself. So here it is, with my compliments:

The class System.DBNull  has a static field Value, which represents the sole instance of the class, so in effect [System.DBNull]::Value is the database null object. Like all objects, it has an Equals method. So [System.DBNull]::Value.Equals($DBField) returns true if $DBField contains a null.

How I use it is to declare the null object up front with script scope
 $DBNull = [System.DBNull]::Value
and then use this wherever in the script I need to test for null, thus
 if($Script:DBNull.Equals($DBField))
{
            <null >
}
else
{
            <not null>
}

Comments
  • Finding stuff about one Microsoft technology isn’t too hard it’s when you try and use two things get

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment