First, books explaining regular expressions:
Kernighan, Pike "UNIX Programming Environment"; unfortunately, out of print for some decades
Larry Wall, et. al. "Programming Perl"; great book, accessible to newcomers to programming, as well as experienced veterans; it covers basic, extended, and Perl exteneded regexps to painful detail (among a plethora of toher things)
As to your question, a regex can find only something that is there

So, the real question is how is the invalid or NULL value represented in the string that you want to search? Beware of empty strings: these can be found between every two characters (i.e. you will find lots of them)