Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

Search/Results with Null Values in DB

Posted 06 Apr 2002 01:59:08
1
has voted
06 Apr 2002 01:59:08 Kent Steelman posted:
Access 2000 with DWUD 4.0. Typically Search window (nothing fancy with list menus to allow the user to select search criteria). I have four list menus for search criteria for the user. The SQL uses the "LIKE" operator with the default of "%" as a wildcard. The variable is passed from the search screen to the results screen. The SQL looks at a view or query in Access.

Where my problem exists is when the data field is "Null". These records are not picked up by the SQL / wildcard. Any suggestions or Hits as to what I am missing.

Wm. Kent Steelman

Reply to this topic