title: How to make the result set of two digit in the SQL query?
body: <p>I have the following query but the results in distance are more than one digit, I want it to be 2 digit only.</p>
  
  <pre><code>UPDATE Customer 
  SET Distance = CAST(CAST(REPLACE(REPLACE(distance, 'km' , '' ), 'miles', '')as float) * 1.3 * 0.62137 AS NVARCHAR) + 'Miles' 
  FROM customer
  </code></pre>
  
  <p>If I have result like <code>2.3434453433</code> then I want it to change to <code>2.3</code></p>