After inserting a new column into a postgres table, I'm unable to find a way to match it in a query.
With the new column dTyp CHAR(1) added, and set to "E" in a couple of places, SELECT kywd FROM myTable WHERE dTyp=NULL; should select all of the other entries, shouldn't it? I've also tried WHERE dTyp='' WHERE dTyp !~ '[a-zA-Z]' but none yield any results. Even WHERE dTyp <> 'E'; yields no results. Am I missing something obvious? (I do get the correct result for "WHERE dTyp='E'" -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode