Arno Brinkman wrote:

> Are the spaces automaticly trimmed? or should it be:
>
> X IN ('01-01-2006', ' 05-15-2006') OR (X BETWEEN ' 02-27-2006' AND '03-01-2006')
>

Since CVT trims numbers and dates, we should trim to not make string
evaluations different.
If one want to pass spaces for strings, he could pass a space escaped: '\ '.

> I like the idea of given multiple ranges, but until now i see a lot of "problems".
>

We resolve the problems. :-)


Adriano