Hi,

> That shows that '-' is not a good separator, so as suggested, and inside
> *one* string:
> X IN LIST ('01-01-2006, 02-27-2006..03-01-2006, 05-15-2006'
>
>> How will the parser translate it back into the first list? How will it know
>> I'm listing date values and that there is exactly one value that I want
>> between 02-27-2006 and 03-01-2006? To it these are just strings and they
>> have no order!
>>
> The parser knows nothing, it only pass the strings to others layers.
>
> Then, each item are separated and evaluated as:
> X IN ('01-01-2006', '05-15-2006') OR (X BETWEEN '02-27-2006' AND
> '03-01-2006')

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')

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

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
General database development support:
http://www.databasedevelopmentforum.com

Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Firebird and Interbase users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info

--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
1010 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!