>From: "rogervellacott" <rvellacott@...>
>
> > Perhaps the engine can detect whether we are comparing a number to a
> > string, and if so, rather than raise an error, just suppress any use
> > of an index for those fields.
> >

At 09:48 AM 3/4/2002 -0600, Woody wrote:

>This just circumvents the real problem which, IMO, is using the wrong data
>types for comparison. .. I tend to think that this "bug" should be fixed to
>always provide an error if trying to compare two totally different data
>types.

You'd outlaw

select id from whatever where entry_date > 'Feb 22 1987'?


Regards,

Ann
www.ibphoenix.com
We have answers.