If any expression in a comparison is null, the result of the comparison is unknown.
For a LIKE operation to provide a true result when searching fields that may contain nulls, the statement must include the IS [NOT] NULL operator.
If any expression in a comparison is null, the result of the comparison is unknown.
For a LIKE operation to provide a true result when searching fields that may contain nulls, the statement must include the IS [NOT] NULL operator.