title: Show result in view in percent
body: <p>I'm working on a database containing of customers, articles, invoices and so on. In MSSQL Server Management Studio I've created a View to show the sale in the invoices and inovoice lines.</p>
  
  <p>Two of the columns in the Invoice table is Sales tax and Discount, that both is in decimals (eg. 0,25 instead of 25%), but in the View I want to show it as percentage. The problem is that I just can't figure out how to do it, so is there any kind soul out there that might be able to help me?</p>
  
  <p>Thanks in advance.</p>
  
  <pre><code>SELECT     TOP (100) PERCENT dbo.Article.AricleID, dbo.Article.Artname, 
      dbo.Invoiceline.Quantity, dbo.Invoiceline.Price, dbo.Invoiceline.Discount, 
      dbo.Salestax.Salestax
  FROM  dbo.Article 
        INNER JOIN dbo.Invoiceline ON dbo.Article.AricleID = dbo.Invoiceline.ArticleID 
        INNER JOIN dbo.Invoice ON dbo.Invoiceline.InvoiceID = dbo.Invoice.InvoiceID 
        INNER JOIN dbo.Salestax ON dbo.Invoiceline.SalestaxID = dbo.Salestax.SalestaxID
  ORDER BY dbo.Invoice.Date
  </code></pre>