Yes. Of course the real application isn't searching for colors. That
was just a quick example.
Sorry for the confusion. Basically I'm trying to find the easiest and/
or the most efficent method
to show rows with ALL 3 terms in any given order without a full text
search if possible.
Of course that may be the only decent method to implement this. I
wasn't sure if there
was any regexp mojo that could be done to implement this.

validus


> Are you suggesting that a desc field could contain all 3 colours in a single
> record?- Hide quoted text -
>
> - Show quoted text -