title: SQL Query Parameters
body: <p>This works just fine:   </p>
  
  <pre><code>Query  = 'SELECT * from table_1 where code = :value; ';
  </code></pre>
  
  <p>I'm however trying to use the LIKE statement and It says that It couldn't find the parameter VALUE In this case:</p>
  
  <pre><code>Query = 'SELECT * from table_1 where code LIKE ''%:value;%''';
  
  Param := ADOQuery1.Parameters.ParamByName('value');
  Param.DataType := ftString;
  Param.Value := 'bob';
  </code></pre>
  
  <p>I wanted to use a backslash to ignore the quotes, because It works in most languages but It looks like It doesn't work in Delphi.</p>