[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
In SQL, how can I remove the newline characters from the value of a column?
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
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
