Strore Proc With Like %

This must be a simple one but look all over to find infos on the uses of like % in a store proc and I did'nt find anything. I know it's something wrong with my "%" and where to put the apostrophes.





Please could you check the following code and let me know what wrong with it.


Thanks





ALTER PROCEDURE dbo.GetSearchMultiColumn


(


@strColumnNamenvarchar (50),


@strSearchTermnvarchar (200)


)





as


if (@strColumnName = 'Camera')


begin


SELECT SystemId,CompanyName,City,State,Country,Camera1,Camera2,Camera3,Camera4 FROM Customers


WHERE Camera1 LIKE '% @strSearchTerm %' or Camera2 LIKE '% @strSearchTerm %' or Camera3 LIKE '% @strSearchTerm %' or Camera4 LIKE '% @strSearchTerm %'


return 0


end





if (@strColumnName = 'ZMotor')


begin


SELECT SystemId,CompanyName,City,State,Country,ZMotor1,ZMotor2,ZMotor3 FROM Customers


WHERE ZMotor1 LIKE '% @strSearchTerm %' or ZMotor2 LIKE '% @strSearchTerm %' or ZMotor3 LIKE '% @strSearchTerm %'


return 0


end





if (@strColumnName = 'Stage')


begin


SELECT SystemId,CompanyName,City,State,Country,Stage1,Stage2,Stage3 FROM Customers


WHERE Stage1 LIKE '% @strSearchTerm %' or Stage2 LIKE '% @strSearchTerm %' or Stage3 LIKE '% @strSearchTerm %'


return 0


end