title: Use a stored procedure to search for a string
body: <p>How can I pass paramenter into a stored procedure and use it to search the database?</p>
  <p>I am trying to search the database for a business name which has the search term within it.</p>
  <p>The following SP can be used to return all results:</p>
  <pre><code>BEGIN
  
  SELECT company.businessname
  FROM company;
  
  END
  </code></pre>
  <p>Returns this result:</p>
  <pre><code>Better Cats Vetinary Practice
  Appliance R'Us
  The Beautiful Flower Company
  Lovely Trips Away
  </code></pre>
  <p>However, if I use the 'searchtext' parameter which is passed in like this, and that parament is given the value of 'appliance' it should return one result, but returns nothing:</p>
  <pre><code>BEGIN
  
  SELECT company.businessname
  FROM company
  WHERE company.businessname LIKE searchtext;
  END
  </code></pre>
  <p>How can I get it to return the one result with 'appliance' in the business name?</p>