title: Sql Server 2008 R2 Full text Search Queries with numerals not working
body: <p>I have a database set up in a SQL Server 2008 R2 Express instance. We have Full Text Support enabled. One of the Tables "Employees" is Full Text Indexed. There is a Column "Address" which is indexed too. </p>
  
  <p>There is a value for the column as follows: "Los Angeles 9"</p>
  
  <p>When we query it by the following:</p>
  
  <pre><code>Select * from Employees Contains (Address, '"Los Ang*"'))
  </code></pre>
  
  <p>It fetches the row correctly</p>
  
  <p>But when we query it by the following:</p>
  
  <pre><code>Select * from Employees Contains (Address, '"Los Angeles 9*"'))
  </code></pre>
  
  <p>Nothing is fetched</p>
  
  <pre><code> Select * from Employees Contains (Address, '"Los Angeles*" AND "9"'))
  </code></pre>
  
  <p>Also fetches none.</p>
  
  <p>I added a new stoplist to the storage section for my database and added just a cursory stop item, thus excluding the removal of numerals from indexing..</p>
  
  <p>But even after this the above mentioned queries fetched a naught.
  Then, I loaded the system default stoplist, removed the numbers 0 to 9 from it, ran the population again.
  Still nothing is being fetched...</p>
  
  <p>Is there anything more to be done??
  Pls advise.</p>