Yes it's possible with f_blobaspchar from FreeAdhocUDF
as it returns a string (32760 octets)

http://www.udf.adhoc-data.de/index_eng.html

example with employee database (before, you must declare functions in
your database with the sql script included with FreeAdhocUDF)

SELECT JOB_CODE, JOB_GRADE, JOB_COUNTRY, JOB_TITLE, MIN_SALARY, MAX_SALARY
, F_BLOBASPCHAR(JOB_REQUIREMENT), LANGUAGE_REQ
FROM JOB
where F_BLOBASPCHAR(JOB_REQUIREMENT) like '%engineer%'

Regards

Alexandre
--- In firebird-support@yahoogroups.com, "robertgilland"
<robert.gilland@...> wrote:

>
> 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?
>