any reason you can't just write:

select * FROM TblTest

where

SupplierId = @Input

OR

@Input = -1

I have NEVER posted a reply to any article before.  But this one deserves some praise.

I'm a developer and constantly bugging my dba for ways to make my apps runs...