haroonqureshi@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