title: Finding max value for a column containing hierarchical decimals
body: <p>I have a table where the column values are like '1.2.4.5', '3.11.0.6',
  '3.9.3.14','1.4.5.6.7', N/A, etc.. I want to find the max of that particular column. However when i use this query i am not getting the max value.</p>
  
  <pre><code>(SELECT  max (CASE WHEN mycolumn = 'N/A'
          THEN '-1000'
          ELSE mycolumn
          END )
  FROM mytable
  WHERE column like 'abc') 
  </code></pre>
  
  <p>I am getting 3.9.3.14 as max value instead of 3.11....</p>
  
  <p>Can someone help me?</p>