title: Is Contains Equivalent To Like In SQL Server
body: <p>When I'm running this query:</p>
  
  <pre><code>Select * from Table1 Where Column1 Like 'aaa%' --3 Result
  Select * from Table1 Where Column1 Like 'a%' --3 Result
  Select * from Table1 Where Column1 Like 'A%' --3 Result
  </code></pre>
  
  <p>but when I'm running </p>
  
  <pre><code>Select * from Table1 Where Contains(Column1 ,'aaa') --3 Result
  Select * from Table1 Where Contains(Column1 ,'a') --0 Result
  Select * from Table1 Where Contains(Column1 ,'A') --0 Result
  </code></pre>
  
  <p><code>CONTAINS</code> can search for:<a href="https://msdn.microsoft.com/en-us/library/ms187787.aspx" rel="nofollow">As Per MSDN</a></p>
  
  <ol>
  <li>A word or phrase.</li>
  <li>The prefix of a word or phrase.</li>
  <li>A word near another word.</li>
  </ol>
  
  <p>Does that mean that <code>Contains</code> can't search for letters?</p>
  
  <p>If yes, then how?</p>
  
  <p><strong>Edit2:</strong></p>
  
  <pre><code>declare @param as varchar(20)='a'
  select * from table1 where Contains(column1,@param)
  </code></pre>
  
  <p>This is Working,</p>
  
  <pre><code>declare @param as varchar(20)='"a*"'
  select * from table1  where Contains(column1,@param)
  </code></pre>
  
  <p>But,This is Not</p>
  
  <pre><code>declare @param as varchar(20)='a'
  select * from table1  where Contains(column1,@param+'*')
  </code></pre>
  
  <p>And,</p>
  
  <pre><code>select * from table1  where Contains(column1,'"'+@param+'*"')
  </code></pre>