How can I remove the newline character from the value of a column. For Example: Select name, comments from table where comment like '%Fine%'; Results: NAME COMMENTS John M. This was a Fine piece of work.
Above, I'd like the Results to appear: NAME COMMENTS John M. This was a Fine piece of work. I tried substr, instr, hedged right ... but can't get it to work. Any help will be greatly appreciated. Regards TS ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]