"Bill" <(E-Mail Removed)> wrote in message

news:(E-Mail Removed) om...

> suppose I have a table with 3 columns: A, B, C, and has the following

> values:

>

> A B C

> 1 2 3

> 4 5 6

> 7 8 9

>

> I want to know what is the best way to find whether there is a row in

> a table that contains 3 different values regardless of the orders they

> are entered. For example, if I enter the search values (5,6,4) or

> (4,5,6) or (4,6,5), or (5,4,6), the search should return true (row 2).

>

> Any suggestions?
I'd loop on first column and check if there is a corresponding value, then

keep all the rows which contained one, and repeat same operation with second

row, etc.. Use a quicksort for the search ( by doing a temporary array )

Sounds good to me. Could be wrong

Just giving ideas in case you need

some.