> FB and IB don't support indexing on expressions.
>
> 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.

Thanks. I was being brain dead.

SELECT DISTINCT SUBSTR(ZIP,1,3) FROM NEWSLET

Best regards