How to edit long text data in SQL Server

Hi Guys,

I have editing a SQL Server table field that have long text data. I am
updating some text in this field. How can I update this field instead
of re-write all text. With the Select command its gives me complete
text in one line and it hard to read it. Any idea. Thanks in Advance

Adnanharoonqureshi@.sympatico.ca (Adnan Jamil) wrote in message news:<6fbfa40b.0310290829.334c8bd6@.posting.google.com>...
> Hi Guys,
> I have editing a SQL Server table field that have long text data. I am
> updating some text in this field. How can I update this field instead
> of re-write all text. With the Select command its gives me complete
> text in one line and it hard to read it. Any idea. Thanks in Advance
> Adnan

I don't really understand what your issue is - perhaps you can give
some more information? Are you trying to replace part of a string? If
so, you can use UPDATETEXT for text columns, or REPLACE() for
char/varchar columns.

Simon