title: how to use between in sql server
body: <pre><code>ID          NAME                     TIME
  ---------------------------------------------
  1   United Arab Emirates    3:00
  2   Sri Lanka                     2:00
  3   Turkey                    4:00
  4   Yemen                     4:00
  5   Us                    11:00
  6   Sweden                    5:00
  7   England                   6:00
  8   Singapore           23:00
  </code></pre>
  
  <p>Dear I want list of name between <strong>2.00</strong> to <strong>10.00</strong> time which is varchar field.
  i did </p>
  
  <pre><code>select * from tblindiantime where IndianTime  between ('1.00') and ('10.00')
  </code></pre>
  
  <p>which gives me wrong records..
  in other cases it shows me conversion erros..
  plz help</p>