title: Max(Date) not working for varchar in SQL Server
body: <p>I have a column 'TransactionDate' of Type 'varchar(15)' and i am trying to get the Max(TransactionDate) using this query</p>
  
  <pre><code>Select MAX(TransactionDate) from MyBank
  </code></pre>
  
  <p>The results are fine as long as Year is same (11/12/2010) but as soon as i put some data with year (12/23/2011) , the query still shows the Max. Date of 2010 instead of 2011.</p>
  
  <p>My Data is as shown below</p>
  
  <pre><code>Name | Age | TransactionDate | Amount
  John | 23  | 12/12/2010      | 2000
  Rock | 24  | 12/23/2010      | 1000
  Sam  | 29  | 1/2/2011        | 5000
  Nomi | 22  | 1/3/2011        | 6000
  </code></pre>
  
  <p>Although the query should return 1/3/2011 but its still returning 12/23/2010.</p>
  
  <p>Thanking in Advance.</p>