Bill, I think you got your LE and GE reversed. Also, it is preferable these days to use >= and <= rather than the letters.

WHERE colstartdate >= .vdate AND colendate <= .vdate

Albert.


On 30/03/2011 2:34 PM, William Stacy wrote:
how about something like WHERE colstartdate LE .vdate AND colendate GE .vdate



Reply via email to