At 06:46 PM 2/23/2001 -0700, Jason Wharton wrote:

> > Thank you very much for the trick about adding || to
> > avoid indexes. It really helps me out. I really like
> > it instead of specifying plan manually.
>
>You are welcome, it surprises me how often I have relied upon this. I can't
>remember exactly who I learned this from but it is one of my little gems.

For what it's worth, Joe Clecko (sp?) mentions it in his book
and I remember a discussion involving Geoff McInnes about the
applicability of the technique to InterBase.


Regards,

Ann
www.ibphoenix.com
We have answers.