[darthvader45]

I've gotten it to display the percentage of markup correctly(as in, multiplied by 100 with no decimal places), but I cannot for the life of me get the percentage sign to display on the right of the values(i.e. 40, but not 40%).

Here's my code so far:

SELECT title, to_char(round((retail-cost)/retail*100), '99') 
AS "MARKUP %" FROM BOOKS;

I've tried concatenating with both the + sign and the ampersand (&) sign, to no avail.

Nvm, managed to get it to work. Will post my solution soon.

[LKBrwn_DBA]

Originally Posted by darthvader45

I've gotten it . . . E t c . . .
I've tried concatenating with both the + sign and the ampersand (&) sign, to no avail.

Perhaps you could try using the "Oracle" concatenating symbol (function)?