[mailto:[EMAIL PROTECTED]
Sent: Saturday, March 22, 2003 5:04 AM
To: Sethi Tarun-ETS017; [EMAIL PROTECTED]
Subject: Re: [SQL] newline character in SQL
Use replace function as documented in
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=functions-string.html
eg in
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:
NAMECOMMENTS
John M. This was a
Fine piece of
work.
Above, I'd like the Results to appear:
NAME
