title: How to use the LIKE operator in a C# Command?
body: <p>I need to insert a string into an Sql Command</p>
  
  <pre><code>search.CommandText = "SELECT * FROM Contacts WHERE Name like ' + @person + % + '";
  </code></pre>
  
  <p>What it the right way of using <code>LIKE</code> in a command?</p>