title: how to check filter length of field in a join query?
body: <p>currently my query looks like:</p>
  
  <pre><code>SELECT * 
  FROM suppliers s 
  INNER JOIN supplier_addresses a 
  ON s.id = a.supplier_id
  </code></pre>
  
  <p>in <code>supplier_addresses</code> there is a field that called <code>address</code> and I want to filter the result of the query above with only the addresses that have char length longer than 10?</p>
  
  <p>i tried to add <code>where LEN(a.address) &gt; 10</code> to the query above but dosent work..</p>