>Thanks for taking the time to respond.
>I'm trying to create the SQL statement which will satisfy all the conditions, and even those that I haven't thought of yet.
Right, but each case will be handled separatly, right? I believe, I answered all 5 cases. You have to add index on cGroup1 and index on cGroup2 and you can easily construct your cases.
I have BtCrit application, that I designed (though not started), which allows to specify user's selection criteria. I was thinking about creating screen shots of it (like Hiten did), but I don't have a place to put them on WEB right now.
If it's not broken, fix it until it is.
My Blog