bmql select best options when fields can be blank
wondering if there is a way to find best record option when 3 of the fields can be blank meaning any input
we have a table that we use a large WHERE clause where 3 of the fields ar:
(Filed1 = X OR Field1 = NULL) AND (Filed2 = X OR Field2 = NULL) AND (Filed3 = X OR Field3 = NULL)
this might return 2 records
Field 1 = X Field2 Null Filed3 Null
Feld 1 Null Field2 Null Filed3 Null
so we would want the best selection where 1 of the fields was a match, or if for example 2 of the fields matched we would want that one...