Re: Select Formatted Text From Table
- From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 25 Oct 2007 21:58:48 +0200
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
.
- Prev by Date: Re: Pulling data that could be in one of 2 tables
- Next by Date: Re: Pulling data that could be in one of 2 tables
- Previous by thread: Re: Pulling data that could be in one of 2 tables
- Next by thread: Table Query
- Index(es):
Relevant Pages
|
|
