tried using BLOBASPCHAR from FreeUDFLib

results returned BLOB data.

Could not find any way to actually search for BLOB text;

ie.

SELECT *
FROM BLOBTABLE
WHERE( UPPER(BLOBFIELD) LIKE '%AND%' )

Can it be done?