title: Sql Server 2008 - FullText rounding money values?
body: <p>Lets assume we have a full text indexed table with those records:</p>
  
  <pre><code>blabla bla bla 101010,65 blabla bla bla 
  blabla bla bla 1012344,34 blabla bla bla 
  </code></pre>
  
  <p>(The decimal separator in Portuguese is "," not "." as in English)</p>
  
  <p>When we execute a query like:</p>
  
  <pre><code>where contains(field, "101011") or
  where contains(field, "1012344")
  </code></pre>
  
  <p>The full text engine is returning those records because it seems to me that it is rounding the numbers as:</p>
  
  <pre><code>101010,65 becomes 101011
  1012344,34 becomes 1012344
  </code></pre>
  
  <p>Is there any way of avoiding that?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Sorry, i forgot to say that the column is a varchar max column and not a currency column. This is happening in this field when it has a float value despite the fact that it is a varchar column</p>
  
  <p><strong>EDIT2</strong></p>
  
  <p>This is not the only data I have in my column. Numbers like those appears frequently on my indexed texts. It is not concatenated. As I said, this is part of the original text and I have done nothing to the original text. I guess this is a behavior of the word breaker, but who knows for sure?</p>