Thanks,

I found my problem was not with the UDF which I had retrieved
from FreeUDFLib. But instead with IBOConsole which I was using to
output the results of the SQL.

Using Database Workbench with the same SQL returned the correct
results

select BLOBASPHAR(DESCRIPTION)
FROM THEDESCRIPTIONS
WHERE(UPPER(BLOBASPCHAR(DESCRIPTION))LIKE '%SERIF%')

This worked good. Thanks for the link to the web site.
I did not know anyone was maintaining FreeUDFLib.
Good to see someone is.

Thanks again.


--- In firebird-support@yahoogroups.com, "amoradell" <amoradell@...>
wrote:

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