Hi SDM,

It could well be that my results were affected by our table size and parameter length as it was a fairly large table and many parameter options (strings) selected. I'm sure a smaller table and less parameters would have different results. We decided to stick with the dynamics SQL as to advantages out weigh the disadvantages.

In the query plan computations stood out most (as expected) and the join was very in-efficient, which is what I expected as well.