add literal percent sign into field as char ?
Posted by: Keith Blackwell
Date: November 22, 2005 04:42PM

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!

Options: ReplyQuote


Subject
Views
Written By
Posted
add literal percent sign into field as char ?
5007
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.