Select Formatted Text From Table   

Hi,
I have a text column in a table and data stored in it contains formatted 
text (with carriage returns, tabs, and spaces).  When I perform a select on 
that column, data returned is non formatted.  How do get the formatted data?

date: Wed, 24 Oct 2007 08:59:01 -0700   author:   Tsheth

Re: Select Formatted Text From Table   

On Wed, 24 Oct 2007 08:59:01 -0700, Tsheth wrote:

>Hi,
>I have a text column in a table and data stored in it contains formatted 
>text (with carriage returns, tabs, and spaces).  When I perform a select on 
>that column, data returned is non formatted.  How do get the formatted data?

Hi Tsheth,

The data is returned as is, including any character retunrs etc. It is
the client program that decides how to display the data.

If you are using SQL Server Management Studio, then you can see the data
formatted by using "Results to Text", or without the carriage returns
and tabs by using "Results to Grid". These options can be found in the
"Query" menu.

-- 
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

date: Thu, 25 Oct 2007 21:58:48 +0200   author:   Hugo Kornelis LID