Concatenation Help

[rctneil]

I have this:

select null, null, null, null, sum("Total")
from tbl_temp

How can I concatenate a '£' infront of sum("Total")?

I am using Oracle by the way

[tripy]

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

should do the trick.
To be tested on an Oracle instance though. I haven't any near me.