> The substring isn't supported in IBO ?
>
> IB0 4.3.A.a

Well, the answer depends on what you mean by that question. There are
full-text search components that can be bought for IBObjects.

You can also use the CONTAINING word or wildcard characters in SQL or
SUBSTRING(<string> FROM <position> FOR <length>). <position> and
<length> must be constants (CONTAINING and SUBSTRING() is part of
Firebird/InterBase and nothing particular to IBO).

If this isn't an appropriate answer to your question, I suggest you
write a little bit of code so that we can see what you actually want
to happen.

Set