title: How to display a time in specific format
body: <p>Using SQL Server 2005</p>
  
  <p>Table1</p>
  
  <pre><code>ID TimeColumn
  
  001 13.00
  002 03.30
  003 14.00
  004 23.00
  005 08.30
  ...
  </code></pre>
  
  <p><hr>
      Table1 Format</p>
  
  <pre><code>TimeColumn Format: HH:MM
  TimeColumn Datatype is nvarchar
  TimeColumn will display the time One Hour or HalfHour
  TimeColumn will not display 08.20, 08.56. It will display the time like 08.00, 08.30.
  </code></pre>
  
  <p>I want to display a time like 13 instead of 13.00, 3.5 instead of 03.30.</p>
  
  <p>Expected Output</p>
  
  <pre><code>ID   TimeColumn  Value
  
  001  13.00       13
  002  03.30       3.5
  003  14.00       14
  004  23.00       23
  005  18.30       18.5
  ...
  </code></pre>
  
  <p>How to make a query for the above condition?</p>