On Mar 28, 8:45 am, Erick T. Barkhuis <erick.use-...@ardane.c-o-m>
wrote:
> canaj...@gmail.com:
>
> > I have a field that stores one of three possible answers: yes, no,
> > maybe
>
> > and I know that if I write:
>
> > SELECT *
> > FROM table
> > WHERE field = "yes"
>
> > I will get all the records where the field = yes, but how do I get it
> > to return all the records when the field equal yes or maybe
>
> SELECT *
> FROM table
> WHERE field = "theFemaleAnswer"
>
> --
> Erick
> [scnr]

No no no -- that would either return ALL records, or SOME of the
records, in a non-deterministic (but not random) fashion.