Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the field

Summary:

Content (required):

We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes

We are currently using Payroll - Personal Payment Details Real Time

So when we are trying to report on these fields that are showing as "Blank" they are not classed as "null" but they are also not classed as a numerical number.

So if you put in a filter of "Is Null" or is not a number nothing gets returned it negates the employees with "No data" in those fields

How can i pull the data showing the employees with "no data" within these Bank Account and Bank Sort Code fields