how to read/update text column?

[Former Member]

I have a table with text column. there is text data in this column.

I want to get the value and update it.

For example, suppose the data for text column is:

this is line 1.

this is line 2.

this is line 3.

this is line 4.

this is line 5. ...

...

this is line 10000.

I want to insert one more line in text value, the new value would be like:

this is line 1.

this is line 2.

this is new line.

this is line 3.

this is line 4.

this is line 5. ...

...

this is line 10000.

I try to use select mytextcolumn from mytab, but only get part of it from output.

how to get the full value and then put it in notepad to edit, then copy.paste it back to database?

[Former Member · Accepted solution]

Found out solution with third party tool. Thanks. I use Sybase central. It's working.