如何在具有自由变异的特定参数的SQL Server中查找数据对

I show table and what I need from SQL Server table with specific parameter with liberal variation from parameter column if parameter pass from variable.I show table and what I need from SQL Server ta