title: Problem with LINQ Where Clause
body: <pre><code>var results =  from formNumber in context.DetailTM 
       join c in context.ClaimPeriodTM on formNumber.ClaimPeriod equals c.Cid
       where formNumber.FormNumber.StartsWith(fNumber) 
              &amp;&amp; formNumber.RegistrationNumber != registrationNumber
       select new { RegNo = formNumber.RegistrationNumber, 
              CP = c.ClaimPeriod, FormNo = formNumber.FormNumber }; 
  </code></pre>
  
  <p>The AND CLAUSE with <code>.StartsWith</code> Doesn't work. If I use == operator the query works fine.  I tried adding brackets to the where clause but it didn't help.  Any idea what is missing.  Thank you in Advance.</p>