Subject RE: [firebird-support] Case insensitive search on a memo field
Author Svein Erling Tysvær
>>Select * from mytable t where t.mymemo like '%find me%'
>You can create a computed index for this:
>CREATE INDEX idxname ON mytable COMPUTED BY (lowercase(mymemo))

Such an index does not help for LIKE '%...', it can only be used if the first character is a real character (i.e. not % or _). Moreover, the index will not be used if you use a parameter rather than constant with LIKE.