title: SQL : Error converting data type varchar to numeric. - I want to add percent sign "%" in data
body: <p>Error converting data type varchar to numeric. -  I want to add percent sign "%" in data     </p>
  
  <pre><code> SUM (Convert(Varchar, CASE 
          WHEN  e.complexity = 'Simple'  AND datediff(DAY, e.entry_date, a.datetime_stamp)
          = 0  THEN 1
          WHEN e.complexity = 'Simple'  AND datediff(DAY, e.entry_date, a.datetime_stamp)
          &gt;= 29 THEN 2
          WHEN  e.complexity = 'Simple'  AND datediff(DAY, e.entry_date, a.datetime_stamp)
          &gt;= 14 THEN 3
          WHEN  e.complexity = 'Simple'  AND datediff(DAY, e.entry_date, a.datetime_stamp)
          &gt;= 8 THEN 4
          WHEN  e.complexity = 'Simple'  AND datediff(DAY, e.entry_date, a.datetime_stamp)
          &lt;= 7  THEN 5
  
  
          ELSE 1
  
       END)*.05 + '%') as total
  </code></pre>
  
  <p>Sample Output: 2.5%</p>