>>What I'm trying to achieve is a single, quick test that will compare 2 sets of states and give the following results:
>>

>>State1 State2 Result
>> T       T      T
>> T       F      F
>> F       T      T
>> F       F      T
>>

>>The first state indicated if something if being used and the second if access is granted. I really want to do this check when creating nodes for a treeview so speed is quite important.
>>
>>Can anyone point me to a solution?
>>Thanks in anticipation.
>
>select State1, State2, State2 or State1 = State2 as Result from myTable
>
>Cetin

Cetin,

Is it possible to do something similar to compare the 2 States if they are strings:

State1 = "TTFF"
State2 = "TFTF"