Subject Re: And not Null From Mervyn Bick <invalid@invalid.invald> Date Wed, 30 Jan 2019 07:02:41 +0200 Newsgroups dbase.getting-started On 2019-01-30 6:55 AM, Mervyn Bick wrote: > In  the SQL statement for a query in OODML one needs to use is instead > of = when comparing a field value. > > e.g  sql = ' ... where something >= 0 and whatever is not null' Still running on the first cup of coffee. :-) That should have read when "comparing a field value for null.".  When testing for actual values = and the other comparison operators work as expected. Mervyn.