Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2004
    sydney, australia

    Post Unanswered: change LF and | in select statement

    using informix isql, in a select statement, i want to REPLACE a pipe with a slash and a linefeed with a space. REPLACE(col,'|','/')etc work fine, but how do i address the LF as REPLACE(col, CHAR(10), ' ')etc grumbles about the clause CHAR The oracle syntax is: translate(a_char_column, '|'||chr(10), '/ ') from a_table;
    Last edited by raylade; 11-10-04 at 22:44.

Posting Permissions

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