title: How to use a variable define with a wildcard and the predicat Contains?
body: <p>If i use the following command with the predicat Contain, i will get all the line where a word is starting by "clav"  (around 20):</p>
  
  <pre><code>SELECT name FROM CUSTOMERS_TABLE WHERE CONTAINS(name, '"clav*"');
  </code></pre>
  
  <p>Now if i'm using a variable, i get no line :</p>
  
  <pre><code>DECLARE @string nvarchar(20) = 'clav*';
  SELECT name FROM CUSTOMERS_TABLE WHERE CONTAINS(name, @string);
  </code></pre>
  
  <p>I try to remove the wildcard and add a specific name > it's working.</p>
  
  <p>Have you got an idea why a variable with a wildcar could not be use with the predicat CONTAINS ?</p>