title: how to select Columns using SQL which has data length greater than given length
body: <p>I have a table with specific columns and rows. I would like to select columns which has data more than length 7.</p>
  
  <p>For ex:
  Table has columns</p>
  
  <pre><code>Name      Address   PhoneNumber
  AAA       AAAAAAAA   12345678
  BBBBB     BBBBBBB    47854
  CCC       FFFF       76643
  </code></pre>
  
  <p>Here columns 'Address   ' and 'Phone Number' has data length more than 7. So it should display,</p>
  
  <p>Address<br>
  PhoneNumber</p>
  
  <p>as results.  This is for a particular table. Here I do not know already that Address and PhoneNumber are the columns which have data greater than length 7. Only from the query result I will be able to find it.</p>
  
  <p><code>SELECT &lt;&lt;all_columns&gt;&gt; from table where length(columns)&gt;7</code> is my input requirement.</p>
  
  <p>The LENGTH or LEN functions in 'Where' clause gives option to give only one specific column name</p>
  
  <p>instead of <code>LENGTH(COL_NAME)</code> , I need option as where LENGTH(&lt;> or something like <code>LENGTH(*)) &gt; 7</code> should be given as input.</p>
  
  <p>How that can be achieved? </p>