>>In VFP, if I have a logical field, I can do something like this:
>>
>>select iID, iif(lLogical, 'Open', 'Closed') from sometable
>>
>>This will return the word Open or Closed depending on the value of lLogical.
>>
>>Since SQL Server does not have an IIF function, how do I do the same thing using Transact SQL?
>
>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. What I am going to do is create a SQL view that contains the PK and the result of the case. Then link that view into my VFP remote view to pull in the text.
Does anybody else have a better solution?