Subject RES: [firebird-support] Case insensitive search on a memo field
Author Fabiano - Desenvolvimento SCI
Post date 2014-09-05T12:11:08Z

You can create a computed index for this:

CREATE INDEX idxname ON mytable COMPUTED BY (lowercase(mymemo))

 

Hope this help you.

 

De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Enviada em: sexta-feira, 5 de setembro de 2014 08:51
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Case insensitive search on a memo field

 

 

Hi,

 

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

 

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?

 

Thanks

Maya