Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Select Formatted Text From Table

  
   Database Forums (Home) -> MSEQ RSS
Next:  Pulling data that could be in one of 2 tables  
Author Message
Tsheth

External


Since: Oct 24, 2007
Posts: 1



(Msg. 1) Posted: Wed Oct 24, 2007 8:59 am
Post subject: Select Formatted Text From Table
Archived from groups: microsoft>public>sqlserver>mseq (more info?)
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?

 >> Stay informed about: Select Formatted Text From Table 
Back to top
Login to vote
Hugo Kornelis

External


Since: Jan 31, 2006
Posts: 335



(Msg. 2) Posted: Thu Oct 25, 2007 9:58 pm
Post subject: Re: Select Formatted Text From Table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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

 >> Stay informed about: Select Formatted Text From Table 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Insert Multiple Rows into a Table Without Using Select - Hi. I want to insert 4 rows into a SQL table. Can I do this without using 4 Insert statements? This is my SQL statement: Insert Into MyTable Values (1,2) (3,4) (5,6)...

Nested select - Can you tell me whats wrong with this query? select count(*) as CountedOrders from ( select distinct [order] from [OrdersTable] where [Customer]='100000' and [Order Date] between '01/01/2005' and '31/12/2005' ) It runs perfect in MS Access but not in...

EXEC (select... ) problem Help! - How can I get this to work? declare @WkEmpID declare @sql varchar(1000) set @sql = 'select distinct @WkEmpID = EmpID from Employee' exec (@sql) Now this is a simplified version of a more comples query which is forcing me to use this method rather than...

GROUP BY's on 3 tables in one SELECT? - Hi there, I'd like to ask you for help with following: having 3 tables: T1 (Person_ID, Product_ID, Costs) T2 (Person_ID, Product_ID, Balancies) T3 (Product_ID, Product_Type) I have simple GROUP BY query: SELECT T1.Person_ID, T1.Product_ID, MAX(Costs)..

How to select all top 1s from different group in a view - Hi SQL Query Guru, I have a view like this: Contract_KEY Step 1 1 1 3 2 1 2 5 2 4 How do I write a query to retrieve the following result: ...
   Database Forums (Home) -> MSEQ All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]