Subject Re: BLOB update in trigger
Author Aage Johansen
On Wed, 19 Nov 2003 21:45:25 +0000 (UTC), Dorin Pacurar wrote:

> I need to update a table - a BLOB field (appendig some lines of text) every
> time a trigger fires. How can I do that ?


Doing this in a trigger (or SP) probably requires the use of UDFs. Convert
the blob into a string, append your lines, and convert back to blob.


--
Aage J.