Ok guys, you are the experts

this is my full sp, now you can tell me if is it worth keeping it as it is in the sql server, or use...

Thank you :w00t:

You are the best, Grant.

😀

I will go with dynamic SQL, but implicitly i hope to find another way ! :hehe:

Thanks anyway 🙂

nice solution

but does it work for nvarchar parameters?

Thank you Andras and Nisha for your replies

In fact Andras, yes, this is a short example of my sp

but the problem here i can not use the IF statement, because...