Hi all I have a question about BETWEEN. Could it be used to look up fields which have a date between to date fields?
Ex: '2005-10-07' BETWEEN tEffectivedate AND tExpirationdate tEffectivedate and tExpirationdate are DATE types. Best Regards, -- Erfan Shirazi Application Developer, Information Technology - Shipco Transport Email: [EMAIL PROTECTED] Phone: +45 39 15 05 63 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]