> There is a textual BLOB field in a table, where the customer stores
> some text (not too long, a few lines of names, addresses, etc...).
> Last week the customer came forward with the idea that it would be
> very nice if he could make a search on this field. No problem, I said,
> I would change the BLOB field into varchar(300) and that's all.

Can't you just search on the blob field directly ?

SELECT * FROM mytab WHERE myblobfield CONTAINING 'longstreet';

Ivan

> I made a new field in the table, and tried to copy the old data:
>
> update MYTABLE set VARCHARFIELD = BLOBFIELD
>
> but got an error message: 'Overflow occured during data type
> conversion. conversion error from string "BLOB" '.