"msnews.microsoft.com" <mav@mav.mav> wrote in message
news:e#8fbQHDEHA.2052@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Is there a way to return a row multiple times if it matches multiple
> clauses?
>
> For example, say i have a column called myNumber and one of the values in
it
> is 5. I can do this query...
>
> SELECT myNumber FROM myTable WHERE myNumber > 4 OR myNumber < 6;
>
> ...and it will return a single 5. What i'm looking to do though is have
the
> number 5 returned twice because it matched both clauses. Is it possible
to
> do this within a single query?
>
> Much thanks,
> Mav
>
>