> How can I move a Blob from one table to another without transferring
> it over the network?
>
> Is that possible?
>
> update table2
> set myblobfield =
> (select anotherblobfield from table1 where id=...)

Yes.

> or is there a better way to do it?
>
> Will it create another instance of the blob

Yes.

> or just copy the blob
> "pointer"? So if I overwrite the blob in table1 after that, will the
> blob in table2 also change or not?

Blob-id is never shared between different fields or tables.

Ivan
http://www.volny.cz/iprenosil/interbase/