Putting a parameter in search query

[cary1234]

    Dim SQL As String = _
            "SELECT Material_Description FROM yourTable WHERE yourTable.Material_Description " _
            & " LIKE @PARAM)"
     
            Dim Input_Param As String = "% " & "Some Parameter" & " % "

I will type those codes inside the event in vb.net??? I cant understand how to use those code. haha! Thanks make me rain.