Subject Re: Filter From AGOSTINHO <AGOSTINHOTEIXEIRA@YAHOO.COM> Date Mon, 13 Dec 2021 23:00:31 -0500 Newsgroups dbase.getting-started Very strange behavior When trying from the command box  "SET FILTER TO BETJ_N <> 'J' then when browsing I get only records with the  betj_n " " (empty) non paid records but when applying this to the rowset property I don't get any records on the grid. What can be wrong here?    Mervyn Bick Wrote: > On 2021/12/13 20:29, Agostinho wrote: > > Dear Mervyn thank you for supporting > > Note that my field contain only 'j' for paid > > invoices and ' ' (empty) for non paid invoices > > > Fine. in that case you don't have to test for 'J'. > >   filter = "betj_n = ' '" works on my test file but didn't work for you > possibly because dBASE may have null values in the field. > > filter = "betj_n <> 'j'"  should return all non-paid records whether the > field contains ' ' or null. > > Mervyn. > >