|Subject||Re: [IBO] Re: searching datasets '%something%'|
> I am not sure, but I think that there is some way how IBO adds theIf you have TIB_Connection.DefaultNoTrailing turned on then searches
> '%' or '*' automatically, but I cannot recall, where it can be set.
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%'
Geoff Worboys - TeamIBO