>>>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"
>

Result=""
for ix=1 to len(State1)
 Result = Result + iif(substr(State2,ix)='T' or substr(State2,ix)=substr(State1,ix),'T','F')
endfor

However you're saying speed is important. For a similar thing where strings are much much longer I use a FLL.
Depending on your needs you might want to FLL, lowlevel check, parsing to array, cursor tricks etc
Cetin