Hello Could someone please explain why:
this query select * from Table where date = "" (returns all records with a null value in the date field) Works where as select * from table where date <> ""(returns "warning no records selected) Stinks!!! Can someone tell me how to select a record from a table with a date formated field where the date is not null. I am getting around it by selecting the field by querying the date so that it is greater than when Columbus was actually living. Thanks _______________________________________________________________________ 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.
