title: Wildcard + SQL Parameter in Procedure
body: <p>I created a procedure in order to search for a product, but I got a problem, as I would like to use wildcards with a param (nam) , but I don't get them to work.</p>
  
  <pre><code>SELECT * FROM PRODUCTS WHERE NAME LIKE NAM + '%'
  
  SELECT * FROM PRODUCTS WHERE NAME LIKE '%'+ NAM + '%'
  </code></pre>
  
  <p>...</p>
  
  <p>Thank you so much.</p>