all groups > sql server mseq > october 2007 >
You're in the

sql server mseq

group:

Select Formatted Text From Table


Select Formatted Text From Table Tsheth
10/24/2007 8:59:01 AM
sql server mseq: 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
Re: Select Formatted Text From Table Hugo Kornelis
10/25/2007 9:58:48 PM
[quoted text, click to view]

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
AddThis Social Bookmark Button