On Saturday 24 February 2001 10:45, you wrote:

> 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.

Its Joe Celko assuming you mean the author of "SQL For Smarties".

--
Brad Pepers
brad@...