Results 1 to 2 of 2
Thread: Concatenation Help
Dec 16, 2008, 12:19 #1
I have this:
select null, null, null, null, sum("Total")
How can I concatenate a '£' infront of sum("Total")?
I am using Oracle by the way
Dec 16, 2008, 12:53 #2
- Join Date
- Aug 2007
- 0 Post(s)
- 0 Thread(s)
It's been a long time I haven't done oracle, but as far as I remember:
select null, null, null, null, '£ '+TO_CHAR(sum(Total), 999999) from tbl_temp
To be tested on an Oracle instance though. I haven't any near me.