SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Wizard rctneil's Avatar
    Join Date
    Jun 2005
    Posts
    1,898
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Concatenation Help

    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

  2. #2
    SitePoint Evangelist
    Join Date
    Aug 2007
    Posts
    566
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It's been a long time I haven't done oracle, but as far as I remember:
    Code:
    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.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •