title: CONTAINS in SQL 2000
body: <p>I have a table 'Asset' with a column 'AssetDescription'. Every row of it has some group of words/sentences, seprated by comma.</p>
  
  <blockquote>
    <p>row1: - flowers, full color, female, Trend<br>
    row2:- baby smelling flowers, heart</p>
  </blockquote>
  
  <p>Now if a put a search query like:-</p>
  
  <pre><code>select * from Asset where contains(AssetDescription,'flower')
  </code></pre>
  
  <p>It returns nothing.</p>
  
  <p>I have one more table 'SearchData' with column 'SearchCol', having similar rows as mentioned above in table 'Asset'. Now if a put a search query like:-</p>
  
  <pre><code>select * from SearchData where contains(SearchCol,'flower')
  </code></pre>
  
  <p>It returns both the rows.</p>
  
  <p>QUESTION:- </p>
  
  <ol>
  <li><p>Why first query doesn't return any result, but second one does correctly.</p></li>
  <li><p>If 'Full Text Search' has something to do with 1st ques, than what to do regarding  that. As I'm using SQL server 2000.</p></li>
  </ol>