Or, even better- "clock*" will find "clocktower", but "*tower" won't!

The static SQL version of the second case.

I would love to do with the WHERE clause what you do with the ORDER BY. Is there a way?

I want to do the same thing with the WHERE clause in SQL7. Basically, I want to dynamically set filters, I just don't know how. And I really...

Excellent, thanks very much everyone! I've got it up and working. I really appreciate all the help. I still can't believe that this kind of basic functionality...

Well, then I guess the next question is how do I put it in a temp table? I'm trying to find a list, "AL,AZ,AK", that's dynamically sent to the...

Nick, other than the select permissions, how bad is the dynamic query option? Does it prevent the optimizer from speeding up these kinds of queries (since it doesn't know...