Richard, I think the query can be simplified further to:-
select * from Table where <DateFieldName> since any rows that have entries in the DateFieldName will return TRUE to this statement. Keith -----Original Message----- From: Richard Glass [mailto:[EMAIL PROTECTED]] Sent: 10 October 2001 23:04 To: Mapinfo-L (E-mail) Subject: MI-L MI Querying Date Fields A big thanks to the people who helped me out, the simplest answer to query a table with a date format to return the records where the date IS NOT NULL is: select * from Table where not (date = "") ------- Bill Thoen is a legend in NZ Please be assured that <> only seems not work only with Date fields. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
