title: What is the best way to parameterize a LIKE query?
body: <p>I'm trying to implement a simple search, using LIKE in my SQL statement:</p>
  
  <pre><code>        Using cmd As New OracleCommand
             cmd.Connection = conn
             cmd.CommandType = CommandType.Text
             cmd.CommandText = "select * from TABLE where FIELD like '%:text%'"
             cmd.Parameters.AddWithValue("text", searchValue)
             ...
          End Using
  </code></pre>
  
  <p>This doesn't work - what is the best way to parameterize the search value?</p>