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.
