Null fields in a database

Question

I've created a database which in some cases a customer may not have a value to enter. In that case I'd like when a search is executed for any Null field to be hidden. Example: <> <> <> When customer does not enter contact name; My Company 800-900-1000