title: T-SQL round to decimal places
body: <p>How do I round the result of matchpercent to two decimal places (%)?
  I'm using the following to return some results:</p>
  
  <pre><code>DECLARE @topRank int
  set @topRank=(SELECT MAX(RANK) FROM
  FREETEXTTABLE(titles, notes, 'recipe cuisine', 1))
  SELECT 
      ftt.RANK, 
      (CAST(ftt.RANK as DECIMAL)/@topRank) as matchpercent, --Round this
      titles.title_id, 
      titles.title
  FROM Titles
  INNER JOIN 
  FREETEXTTABLE(titles, notes, 'recipe cuisine') as ftt
  ON
  ftt.[KEY]=titles.title_id
  ORDER BY ftt.RANK DESC
  </code></pre>