Hi Raymond, thanks for your reply.

Yeah, I was aware of this workaround (I have the most-valuable GSG),
but to me this defeats the purpose of normalisation, and I also do
not want purely uppercase fields.

The BDE lookup's can handle this, so I just thought I may have not
been doing something correctly.

Rgds,
-Ryan

--- In IBObjects@y..., Raymond Kennington <progsol@c...> wrote:
> Ryan Nilsson-Harding wrote:
> >
> > Hi there,
> >
> > I'm not sure if this is obvious or not.
> > I have SeekNearest = True, but when seeking, it does not
treat 'M'
> > and 'm' as the same (I'm aware they're not the same, BTW).
> > So if I have only one supplier, say 'Marvin' and I type in 'm',
it
> > does not locate Marvin.
> >
> > Is there a way to make this locate case-insensitive?
>
> Create a separate field in the table that is all uppercase and
update it in BeforeUpdate
> and BeforeInsert Triggers.
>
> In IBObjects specify that the field to use is the uppercase field
when searching.
>
> This is explained in the User Guide (about $30).
> --
> Raymond Kennington
> Programming Solutions
> W2W Team B