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?