Re: How to add a new line inside the columns

No, what I want is to replace a specific pattern to a new line character.
Assume I use 'XYZ' as the pattern, then for every string which matches 'XYZ', add a new line. Since there will be a web application (which we are not able to use its API to process the display) accessing the database, we really need that while we use simple "select" statement, we would get the results without further SQL formatting.

chisuen_at_hotmail.com (chisuen) wrote in message news:<fbed5686.0107311624.5a7f28ad_at_posting.google.com>...
> In one column, I want to insert a new line to it, how would I do it?
>
> Ex:
> Table
> Column1 (ID) Column2 (Name)
> ------------ ---------------
> 001 First Last
>
> How do I change it to
>
> Column1 (ID) Column2 (Name)
> ------------ ---------------
> 001 First
> Last
Received on Thu Aug 02 2001 - 00:15:01 CEST