Putting A Parameter In Search Quer?

I have a query in my sql builder like this

SELECT *
FROM canvasstable
WHERE (Material_Description LIKE '%a%')

That code is 100% working. My problem is I cant change it to something like this

SELECT *
FROM canvasstable
WHERE (Material_Description LIKE '%' + @parameters +'%')

I also tried something like this

WHERE (Material_Description LIKE CONCAT(@param, '%') AND = CONCAT('%', @param)