| Subject | Re: [firebird-support] Searching BLOB fields for text |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2007-12-18T15:07:18Z |
> Could not find any way to actually search for BLOB text;WHERE BLOBFIELD CONTAINING 'AND'
>
> ie.
>
> SELECT *
> FROM BLOBTABLE
> WHERE( UPPER(BLOBFIELD) LIKE '%AND%' )