RE: [firebird-support] Case insensitive search on a memo field

[Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]]

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

Set