Running SAGE 100 v2018 and am trying to export data from the AP_OpenInvoice table where the CheckNo is not blank.  I've gone into the Export Select tab, selected CheckNo, selected the Relation as "Not Equal (<>)".  For the Selection Value I've tried leaving the field blank, adding spaces, entered "null", and entered "0".  However, every time I've run the report, I'm getting transactions that have a blank CheckNo.

I opened SQL and ran a simple query where I look for a specific Invoice (that I know does not have anything in the CheckNo field) and where the CheckNo is not equal to: '0' (didn't find the record); '_' (didn't find the record); 'null' (found the record)...however, I don't know how to translate that into the VI Export job.