>>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?
Insanity: Doing the same thing over and over and expecting different results.