>>>Assuming a bit field (or numeric) where 1 = True and 0 = False:
>>>

select iID, mylogical =
>>>   case
>>>   when llogical = 0 then 'Closed'
>>>   else 'Open'
>>>   end
>>>from sometable

>>
>>This works fine in Query Manager but does not work in a remote view.
>
>Yes it does. What does it not do for you?

It does not work in a VFP remote view.