BLOB

Hi,

How do I check if a blob field is empty or null? I want to update a column where the blob field is not null. I tried IS NOT NULL but it keeps on updating all the records. My syntax is:

    UPDATE table
    SET column1 = 'something'
    WHERE blobfield IS NOT NULL;

Any help is much appreciated.

Thanks,
Arman Received on Wed Oct 30 2002 - 15:51:39 CST