Hello,

I need to make a update on a blob field like this:

update table1
set BlobFiled = 'Begin Text ' || BlobField || ' End Text'
where ....

I've do that and get an error: Conversion Error from String "BLOB"

update table1
set BlobFiled = 'Begin Text ' || cast(BlobField as varchar(200)) || ' End Text'
where ....

The same error...

How can I do this?

Tanks for attention...

--------------------------------------
Greetings,
Jean Derrie Rigo
rigo@...
--------------------------------------