Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    now in UAE, i am an INDIAN.
    Posts
    16

    Unanswered: Replace end of line character with comma

    Hi all,

    One of my text column contains end of line character in between , which are invisible, how can I replace it with comma?
    eg:
    select column1 from table1

    Result will look like below

    SUPER Savings
    Term Cap
    Super Logo
    My Protection
    My Education
    Vision Critical


    all the above values are in a single record.

    I need it like
    SUPER Savings,Term Cap,Super Logo,My Protection,My Education,Vision Critical


    appreciate your help

    thanks
    TEAM (Together Everybody Achieve More)

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    REPLACE(myCol, CHAR(10) + CHAR(13), ',')
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Oct 2003
    Location
    now in UAE, i am an INDIAN.
    Posts
    16
    that's cool ...
    thanks pootle flump
    TEAM (Together Everybody Achieve More)

Posting Permissions

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