Based on my experience, the one using Dynamic SQL is the best solution. using or operator is not recommended,

1.cause it will SQL Server to misuse index.

2.When the...