title: mssql display 1 decimal point if available, else show none
body: <p>Simple one I think.</p>
  
  <p>I have a query that shows lengths of items.</p>
  
  <p>Query:</p>
  
  <pre><code>select length from vw_OutstandingVsInStock1 OVI
  LEFT JOIN Departments DEP
  on OVI.Department COLLATE DATABASE_DEFAULT=DEP.Description
  where OutstandingVolume&gt;0.39 
  </code></pre>
  
  <p>This returns results like:</p>
  
  <pre><code>0.9
  1.2
  1.5
  1.8
  2.1
  2.4
  2.7
  3.0
  3.3
  3.6...
  </code></pre>
  
  <p>In the case of <code>3.0</code> I want it to display as <code>3</code></p>
  
  <p>so if no decimal value, show <code>int</code> with no decimals. if a decimal exists show decimal to 1 decimal point?</p>
  
  <p>so desired output is <code>3</code> and <code>6</code> instead of <code>3.0</code> and <code>6.0</code></p>
  
  <p>I am using MSSQL 2012.</p>