Hi,

I have a table with records already existing. I would like to add an image file into the records, and the image field is Long Binary. So basically, I'm just using an UPDATE statement to add this image. However, using xp_read_file always returns NULL.

The SQL I use looks something like this:
UPDATE mytable SET imgfield = xp_read_file('image.bmp')

I also tried using absolute directory paths to the image file, but still a NULL value is returned. I also tried using an INSERT statement to append a record into the database and the image file at the same time, with no results either.

I appreciate any suggestions. Thanks!