I have a table that stores images (bmp files) in a field (item.image) as an image type. In enterprise manager, all fields show up as binary.
I have another table that has a field for the picture name (item_ext.picname). The pic name has some bad data in it where a pic name exists for an image that does not.
I would like to create a SQL statement that would look at the image type field and if a picture does not exist, then replace the picname with null. I do not understand the image/binary field well enough to do this. Any suggestions on how this could be completed?
Thank you,
CF
I have another table that has a field for the picture name (item_ext.picname). The pic name has some bad data in it where a pic name exists for an image that does not.
I would like to create a SQL statement that would look at the image type field and if a picture does not exist, then replace the picname with null. I do not understand the image/binary field well enough to do this. Any suggestions on how this could be completed?
Thank you,
CF