How to fill an blob field

[Geri2]

Hi all,
I have a little problem. I want to use a the image datatyp but I don't know how to fill it.

Can somebody tell me step by step how it works?

Thanks

Geri

 

[Geri2]

Sorry I forgot what I use.

I use MS SQL Enterprise Manager on Version 8.0..

 

[JBaileys]

Geri,

I suggest looking at the writetext and readtext functions.

Code includes:

Declare @ptrval binary(16)
select @ptrval = textptr(<<imagefield>>)
from <<table>>
where ...
writetext <<table>>.<<imagefield>> @ptrval 'my text...'
go