title: Linq to SQL Join and Contains Operators
body: <p>in the following query</p>
  
  <pre><code>  var restrictions = from p in dcTrad.quop_restricted_items
                             where p.entry_status == 'P' &amp;&amp; p.batch == "PRODUCTION" &amp;&amp; p.problem != null
                             from q in dcTrad.model_companies
                             where   q.co_name != null &amp;&amp; p.brimsec == q.primary_bsec                            
                             select new { Company = q.co_name, Restriction = p.comment ?? "Restricted without comments", Portfolio = p.problem };
  </code></pre>
  
  <p>I need to replace </p>
  
  <pre><code>p.brimsec == q.primary_bsec 
  </code></pre>
  
  <p>with </p>
  
  <pre><code>p.brimsec.StartsWith ( q.primary_bsec  )
  </code></pre>
  
  <p>but I get the following error:</p>
  
  <pre><code>Only arguments that can be evaluated on the client are supported for the String.StartsWith method
  </code></pre>
  
  <p>How can I make this work? </p>