How to return a long string

Hi,
I have a SQL script it returns a long string (more than 600 characters),
however I can only catch 256 characters. How to get whole characters?
thanks in advanceTools | Options
Results tab
Maximum characters per column
Keith
"Li Pang" <LiPang@.discussions.microsoft.com> wrote in message
news:CB8B888B-4406-46B2-8EE6-53B8839F258D@.microsoft.com...
> Hi,
> I have a SQL script it returns a long string (more than 600 characters),
> however I can only catch 256 characters. How to get whole characters?
> thanks in advance|||You didn't write where you are trying to get the string, so I guess
that you run the SQL statement in the Query Analyzer. If I'm correct,
then you need to modify the Query Analyzer's configuration. You can
do it Tools-->Option-->Results. Then just modify the number of
characters per column.
Adi|||Thanks
"Keith Kratochvil" wrote:

> Tools | Options
> Results tab
> Maximum characters per column
> --
> Keith
>
> "Li Pang" <LiPang@.discussions.microsoft.com> wrote in message
> news:CB8B888B-4406-46B2-8EE6-53B8839F258D@.microsoft.com...
>|||FYI, max in SQL Server 7.0/2000 is 8,192.
http://www.aspfaq.com/2272
http://www.aspfaq.com/
(Reverse address to reply.)
"Adi" <adico@.clalit.org.il> wrote in message
news:1106573590.672085.19500@.f14g2000cwb.googlegroups.com...
> You didn't write where you are trying to get the string, so I guess
> that you run the SQL statement in the Query Analyzer. If I'm correct,
> then you need to modify the Query Analyzer's configuration. You can
> do it Tools-->Option-->Results. Then just modify the number of
> characters per column.
> Adi
>