title: Select MAX INT value of TEXT column
body: <pre><code>UserID    UserName  Password
  
  1                abc               123
  10               xyz               456
  3                mno               254
  
  SELECT MAX(UserId) AS UserId FROM UserLogin
  </code></pre>
  
  <p>When I run this query it gives me 3 instead of 10</p>
  
  <p>All columns are TEXT datatype</p>