On Friday 2001-09-14 at 09:32:19 +0200, Nando Dessena wrote:

> David,
>
> > Personally, I don't recall having any success with 'XY%' and for some
> > unknown reason have always had to use '%XY%'. Seems weird to me, but
> > that has been my experience.
>
> what do you mean? 'XY%' and '%XY%' serve different purposes.
> What did you expect from 'XY%' to say it didn't work?

What I meant was that the row(s) that should have matched didn't. Now,
this was a long time ago (well, a year or two), and my memory isn't
very clear about it. I'm not even 100% sure (only 98%) that it was
InterBase I was having the difficulty with. It could have been Oracle,
or even MS Access.

Anyway, it's probably a moot point, since there is no doubt no problem
now, and anyone who tries it will certainly find out one way or the
other!

Ciao 4 niao.

David Trudgett