How to edit long text data in SQL Server

[Adnan Jamil]

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

[Simon Hayes]

ha***********@sympatico.ca (Adnan Jamil) wrote in message news:<6f**************************@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