|Subject||Re: [ib-support] Index on Sub String|
|Author||Robert F. Tulloch|
> FB and IB don't support indexing on expressions.Thanks. I was being brain dead.
> Create a proxy search column of the required size which is populated automatically by a trigger which writes the substring into it, and index that.
SELECT DISTINCT SUBSTR(ZIP,1,3) FROM NEWSLET