Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    12

    Unanswered: Update statement

    Hi all,

    I have a problem. In one of the column (varchar2 of 4000) the data is store along with enter key. I want to replace it with space character. I tried using replace function.... replace(column1,'
    ',' ') but, no change in output.

    any other solution ???

    thx, in advance.
    raghu.

  2. #2
    Join Date
    Aug 2003
    Posts
    41
    Try CHR() functions in your replace. You can specify ASCII values there.

    -Sunil

Posting Permissions

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