# Teradata, SQL, converting numeric to Char & add %

**URL:** <https://forums.toadworld.com/t/teradata-sql-converting-numeric-to-char-add/7525>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 1, 2013, 9:59am UTC](https://forums.toadworld.com/t/teradata-sql-converting-numeric-to-char-add/7525 "2013-02-01T09:59:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wpoling\_953](https://avatars.discourse-cdn.com/v4/letter/w/f1d935/32.png) [@wpoling\_953](https://forums.toadworld.com/u/wpoling_953)\
**Post date:** [February 1, 2013, 9:59am UTC](https://forums.toadworld.com/t/teradata-sql-converting-numeric-to-char-add/7525/1 "2013-02-01T09:59:08Z")

</div>

Hi, trying to convert a numeric value to char and add % sign.

Getting error that I am missing something "like ‘(’ between the ‘VarChar’ keyword and ‘,’

Any thoughts please?

Thank you

WHP

SELECT “Med or Surg” AS “Med or Surg”  
, COUNT(_) AS “Total Admits”  
, SUM(“30DyReAdFLG”) AS “Flagged ReAdmits”  
, COUNT(_) - SUM(“30DyReAdFLG”) AS “Non Flagged Readmits”  
, CONVERT(VARCHAR, SUM(“30DyReAdFLG”)\* 100 / COUNT(\*)) + ‘%’ AS Percentage

FROM ar\_asrh\_dm\_etl\_beacon.Flg\_ReAdAlgo1a2  
WHERE AdmitProvRend\_id2 = 139874  
GROUP BY “Med or Surg” ORDER BY “Total Admits” DESC;

---

<div class="post-metadata">

**Author:** ![AlekseyBazhenov](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@AlekseyBazhenov](https://forums.toadworld.com/u/AlekseyBazhenov)\
**Post date:** [February 1, 2013, 12:03pm UTC](https://forums.toadworld.com/t/teradata-sql-converting-numeric-to-char-add/7525/2 "2013-02-01T12:03:29Z")

</div>

Try to use this one

cast(SUM(“30DyReAdFLG”)\* **100** / COUNT(\*) as **varchar** ( **10** )) || ‘%’ AS Percentage

Aleksey

---

<div class="post-metadata">

**Author:** ![wpoling\_953](https://avatars.discourse-cdn.com/v4/letter/w/f1d935/32.png) [@wpoling\_953](https://forums.toadworld.com/u/wpoling_953)\
**Post date:** [February 1, 2013, 4:45pm UTC](https://forums.toadworld.com/t/teradata-sql-converting-numeric-to-char-add/7525/3 "2013-02-01T16:45:59Z")

</div>

Thank you Sir. Very helpful!

WHP