title: Add parameter issue for fulltext search in C#
body: <p>I have this part of code</p>
  
  <pre><code>string query = "SELECT ID, COL1 FROM TABLE1 WHERE CONTAINS(COL1,@text)";
  
  sqlCommand.CommandText = sql;
  sqlCommand.Parameters.Add("@text", value+"*");
  </code></pre>
  
  <p><code>value</code> is a function parameter.</p>
  
  <p>For fulltext search, the sql statement must be like this:</p>
  
  <pre><code>SELECT ID, COL1 FROM TABLE1 WHERE CONTAINS(COL1,'"eng*"')
  </code></pre>
  
  <p>It could search strings which start with "eng" -> english, bla blah.</p>
  
  <p>But executing in C# the above code then <code>ExecuteReader()</code> returns empty list.</p>
  
  <p>@text has as value <code>"sometext*"</code> but I want to add <code>' '</code> characters.</p>
  
  <p>I tried <code>string query = "SELECT ID, COL1 FROM TABLE1 WHERE CONTAINS(COL1,'@text')";</code>
  but it doesn't work, returns empty list.</p>
  
  <p>Why ? How do I proceed that <code>@text</code> parameters must include <code>''</code> characters over value for search ?</p>
  
  <p>Thank you</p>