>Hi,

>I’m using Firebird 2.5.3, and I am looking for text in a memo field, eg.

I take it you mean BLOB or VARCHAR, I’ve never heard of memo fields in Firebird?

>Select * from mytable t where t.mymemo like ‘%find me%’

>The will only find

>“find me”

>and not

>FIND ME or

>Find me or

>Find Me etc

>  

>I’m tempted to do something like

>Select * from mytable t where lowercase(t.mymemo) like ‘%find me%’

>but since this memo field could be enormous, I’m guessing that wold be horribly inefficient.

>Is there a better way?

I think SELECT * FROM MYTABLE WHERE MYMEMO CONTAINING ‘FIND ME’ is case insensitive. One, probably better, alternative would be to use a case insensitive collation, but I doubt collations can be used in blobs (it should work in a varchar). And you’re right, it will be slow since no indexes can be used (hopefully, we’re not talking about more than a few million rows in this table?)…

HTH,

Set