I'm trying to do this:

select * from mytable where upper(myblob) like '%SOMETHING%'

But I get an error "conversion error from string BLOB".

Works fine without the upper().

It seems to work fine using:

select ... where myblob containing 'SOMETHING'

and this also seems to be case-insensitive.

Have I got this right??

Thanks,

John