I have added a new field FIELD_1 (domain CHAR10) to a already existing Z table, recreated the "Table Maintenance Generator" and transported the table to Test server. Test data exists on test server with some records having FIELD_1 populated and others having FIELD_1 blank.
The following query when executed on test server fetches no records though many records satisfying the WHERE condition exists.
WHERE FIELD_1 EQ SPACE.
Also, it should be noted that the below query fetches proper records as expected.
WHERE FIELD_1 NE SPACE.
Why does the first query fail to fetch records?