var results =                  from formNumber in context.DetailTM 
                                               join c in context.ClaimPeriodTM on formNumber.ClaimPeriod equals c.Cid
                                               where formNumber.FormNumber.StartsWith(fNumber) && formNumber.RegistrationNumber != registrationNumber
                                               select new { RegNo = formNumber.RegistrationNumber, CP = c.ClaimPeriod, FormNo = formNumber.FormNumber }; 

The AND CLAUSE with .STARTSWITH 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.