title: solve numeric overflow problem when converting to float
body: <p>I have a float value that i need to do some calculations on and insert into a numeric(9,2). However in rare (and likley erronous) cases there are some data anomolies and I end up with a value that will not fit into numeric(9,2).</p>
  
  <p>What is a good solution to this problem? Maybe just use 9999999.99 if the number is 9999999.99 or greater?</p>
  
  <p>Any better ideas (besides of course changing the column data type)</p>
  
  <p>Thanks!</p>
  
  <p>EDIT: </p>
  
  <p>I just wanna make the thing run without error.
  I can't "correct" the data.
  I can't omit it because then when I do a sumation there will be no indication that this value is wrong.
  We are talking a FRACTION of a FRACTION of a percent of the data has this issue. 
  Just need to make the query run.</p>