Subject FALSE or <> or not From rouke <moc.liamg@rekkabrg> Date Wed, 30 Dec 2020 16:30:07 -0500 Newsgroups dbase.getting-started In dbase plus 8 with ADO I have a simple table with a few character, date, numeric fields and a logical field. The logical field (field name 'returned') is a tick box. I have double clicked some of the tick boxes and left some as they were. The double clicked tick boxes show a tick, the other ones don't. I assume the ones that do not show a tick are .F. or .N. and the ones that do show a tick are .T. or .Y.. If I 'set filter to returned', all records with ticked tick boxes show, when I 'set filter to not returned' only those records with unticked tick boxes show. But when I 'set filter to returned = .F.', a seemingly random and much smaller number (only 3) of records show, albeit with the tick boxes unticked. When I 'set filter to returned<>.T.', all records with an unticked tick box show. So I wonder, what's the difference between FALSE or <> or not? Rouke