On 07/10/2005, Erfan Shirazi wrote: > 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.
What happened when you tried? -- felix -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]