Read through that a couple times Kev, it appears the logical operator applies to multiple filters within the same column. My goal is OR's between filters on different columns....

If you decide to try using dynamic SQL, give this a read first...

The Curse and Blessings of Dynamic SQL

I too enjoyed the article and thought it would a great time to pimp one of my own blog posts being that it's closely related to this topic.

The post covers...

'SET QUOTED_IDENTIFIER OFF' means identifiers can not be designated with double-quotes and must follow all appropriate identifier rules. You'll see this statement most of the time when an INSERT/UPDATE...

Brian - Just wanted to mention how much I enjoyed the article. It's very well written and is a thorough introduction to the not-so-simple concept of how to set...

FWIW, I like to think of all the replication alternatives and group them by granularity. I find it easier to narrow down the potential solutions that way.

In your case,...

Gail - You're 100% right; I stand duly corrected. I should have gone back and reread the OP. Was thinking that there were more than just those 2...

T-SQL doesn't allow you to build BETWEEN statements that way. If you truly have the need to pass in the "boundaries" that way then your best bet is to...

As Gail stated, your statement is incomplete. The only way you can pass in a "1 and 4" parameter and have it work would be to build the sql...