On 3 Mar 2005 at 17:51, Chad Z. Hower aka Kudzu wrote:

>I have a blob (text) that I need to update with some data from some
>other fields. This is a new field in the table, and for historical
>purposes I need ot just fill in the data for existing rows. The system
>will populate new rows.
>
>I need to embed some EOLs though. So something like

Helen's suggestions won't help you because BLOB can't be updated
this way.
BLOB is a big bunch of bytes. It is stored and retrieved as a
whole. There is only one way to add something to BLOB: get it's whole
content to client application, modify and put back.
--
SY, Dimitry Sibiryakov.