title: LINQ query, ignoring results with certain decimal points
body: <p>I need to perform a LINQ query on a large database in C#. One of the columns I need to use in the query is a double. I need to omit results that have more than 4 decimal places in this column. The database can't be changed as other programs need to use it and make use of what I don't want. The results are then added to a list to use later. I thought that this would work.</p>
  
  <pre><code>where fun.Units != '*.?????*'
  </code></pre>
  
  <p>However it returns the error that too many characters are in the character literal.
  The whole query looks like this so far</p>
  
  <pre><code>var clientQuery1 = from cli in main1.Clients
                     from pol in main1.Policies
                     from fun in main1.FundHoldings
                     from uni in main1.UnitPrices
                     where cli.AccountNumber == accNum
                     &amp;&amp; pol.ClientRef == cli.ClientRef
                     &amp;&amp; fun.FKeyRef == pol.PolicyRef
                     &amp;&amp; uni.UnitPriceRef == fun.UnitPriceRef
                     &amp;&amp; fun.Units != '*.?????*'
                     select uni.UnitName;
  </code></pre>