Geoff,

thanks for the suggestion. It sounds like the best work around at this
stage, though if I am understanding him correctly Jason doesn't think it is
necessary. Maybe I am flogging a dead horse here, but it is tantalizing
because it so nearly works :-)

Best regards,

Brian

> -----Original Message-----
> From: Geoff Worboys [mailto:geoff@...]
> Sent: Friday, 1 December 2000 9:32 AM
> To: IBObjects@egroups.com
> Subject: Re: [IBO] TIB_LookupCombo case insensitive inc search
>
>
> Brian,
>
> > I understand the advantage of having a proxy column
> > of UPPER case strings for searching, but it is hardly
> > justified for short list of a dozen or so rows.
>
> In small tables I setup the uppercase duplicate column as
> COMPUTED BY( UPPER(Base_Field) );
>
> This allows me to change my mind later and setup a real duplicate
> column with its own index (if the table grows unexpectedly) - and not
> have to change the application.
>
> FWIW
>
> Geoff Worboys
> Telesis Computing
>
>
> -------------------------- eGroups Sponsor
> -------------------------~-~>
> eLerts
> It's Easy. It's Fun. Best of All, it's Free!
> http://click.egroups.com/1/9699/1/_/685810/_/975634300/
> --------------------------------------------------------------
> -------_->
>
>
>