>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