> I am not sure, but I think that there is some way how IBO adds the
> '%' or '*' automatically, but I cannot recall, where it can be set.

If you have TIB_Connection.DefaultNoTrailing turned on then searches
will automatically do STARTING 'xxxx'

For example typing; 'Rob'
will search STARTING 'Rob'

IBO will accept either '%' or '*' as wild cards.
If you type a wild card into the search then the search is
automatically issued as LIKE 'xxxx'

For example typing; 'Rob*'
will search LIKE 'Rob%'

typing *ob* (or %ob%)
will search LIKE '%ob%'


hth

--
Geoff Worboys - TeamIBO
Telesis Computing