[MSSQL] Insert bytes into an IMAGE field

[Verwijderd]

Hi all,

I am wondering how to insert about 100,000 zero-bytes into an image field. I've tried WRITETEXT like
this:

WRITETEXT Table1.ColumnA @ptrval REPLICATE(CHAR(0),100000)

But that doesn't work (probably because it expects a literal or variable, not functions?). However,
it makes clear what I want to do:

When I insert a new record into Table1, I want 100,000 bytes (with value 0) to be inserted into Column1.
Please note that the number of bytes to be reserved may be different for each record.

I would really appreciate it if someone could help me out with this problem, because I'm really stuck.

Thanks in advance.

Kind regards,


R. Schuil

[D2k]

in case you didn't notice, this is a dutch board so only questions in Dutch will be answered.