Hello, I have a query in my sql builder like this

Code:
SELECT    *
FROM            canvasstable
WHERE        (Material_Description LIKE '%a%')
That code is 100% working. My problem is I cant change it to something like this

Code:
SELECT    *
FROM            canvasstable
WHERE        (Material_Description LIKE '%' + @parameters +'%')
I also tried something like this

Code:
WHERE        (Material_Description LIKE CONCAT(@param, '%') AND = CONCAT('%', @param)
Please Help I really need it as much as possible. This is for our system.