B
Bill
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?
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?