title: How to find longest string in the table column data
body: <p>I've a table contains the columns like</p>
  
  <pre><code>  Prefix    |  CR
  ----------------------------------------
    g         |  ;#WR_1;#WR_2;#WR_3;#WR_4;# 
    v         |  ;#WR_3;#WR_4;#
    j         |  WR_2
    m         |  WR_1
    d         |  ;#WR_3;#WR_4;#   
    f9        |  WR_3
  </code></pre>
  
  <p>I want to retrieve data from <strong>CR</strong> column WHERE it has the longest text string i.e in current table it is <strong>;#WR_1;#WR_2;#WR_3;#WR_4;#</strong>.
  I'm using </p>
  
  <pre><code>SELECT max(len(CR)) AS Max_Length_String FROM table1 
  </code></pre>
  
  <p>But it retuns </p>
  
  <pre><code>Max_Length_String
  ----------------------------------------
  26
  </code></pre>
  
  <p>But what i need is not the length (26), i wanted like this </p>
  
  <pre><code>Max_Length_String
  ----------------------------------------
  ;#WR_1;#WR_2;#WR_3;#WR_4;# 
  </code></pre>