Hi there,

I´m trying to export a "ntext" field in which I have
stored notes (a lot of text). I'm using the Query
Analizer, but the select command only returns the first
line of the text in each field. It seems that when an
enter is found it just finishes displaying the text of
that field.

Anyone has any idea how i can display the entire text in
each field?
Thanks in advance.

Hi

The following seems to work fine for me:

create table longtext ( col1 ntext )

insert into longtext (col1) values ( N'abc124' + char(13) + char(10) +
N'def' )
insert into longtext (col1) values ( REPLICATE(N'abc1234567890',30) +
char(13) + char(10) + N'def' )

select * from longtext

Make sure that on the tools/options/results tab/maximum characters per
column setting is not the cause for your results.

I am not sure why you aren't using bcp for the export with the -n parameter.

John

"Charles" <carlos.espinoza (AT) itesm (DOT) mx> wrote

Hi there,

I´m trying to export a "ntext" field in which I have
stored notes (a lot of text). I'm using the Query
Analizer, but the select command only returns the first
line of the text in each field. It seems that when an
enter is found it just finishes displaying the text of
that field.

Anyone has any idea how i can display the entire text in
each field?
Thanks in advance.