add literal percent sign into field as char ?
Hi
I have this field... a number....
ROUND((COUNT(c.ACCTNBR) * 100)/s.BEDCT) AS PCTOCC
It behaves correctly... gives the correct values. I would like to add a literal percentage sign to the end, so that a sample result might be "25 %" (without the quotes).
I've tried adding
+ '%'
+ "%"
+ '\%'
right before the AS PCTOCC, with no luck.
I've also tried CAST(expression AS CHAR) + '%', no luck.
What's the best way to accomplish this?
Thanks!
Subject
Views
Written By
Posted
add literal percent sign into field as char ?
5156
November 22, 2005 04:42PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.