title: How to Query by String Length in Google Sheet
body: <p>I need to use query in Google Sheet Spreadsheet to return text in Column B of a given length, and various other conditions. To make it easy, below is a simplified version concentrate solely on Len() function. Seems simple enough but unfortunately does not work.  </p>
  
  <pre><code>=QUERY(Valuations!B1:B,"select B where LEN(B)&gt;3 ")
  </code></pre>
  
  <p>I'm aware that SQL uses LEN(), where as LENGTH() for MySQL. </p>
  
  <p>Are my syntax incorrect or it is not possible to check string length in Google Sheet Query? </p>