This content has been marked as final. Show 4 replies
Normalize your database and then you'll be able to write efficient queries.
My database is normalized and I can easily find all the events on a specific date using the above method.
What I'd like to do is query the date list for a date that is greater than or equal to the requested date.
> I'm saving these dates (one to twenty individual units, using a 20060810-type code,
> separated by a delimiter) in a single field.
Could you post the data from a field that has multiple dates in it?
Over night, I've decided to handle the issue in another way (separate table), so my needs are resolved. That said, after overnight pondering on the subject, I do not think that the task could have been done through a single SQL statement. Thanks for offering to help!