>Maybe I just drempt it but I thought somewhere I saw a TSQL construct other than the CASE WHEN that emulated the behavior of the VFP IIF()
>
>I'm converting a large number of local views in VFP to remote views and there are alot of IIF statements and I thought the last itme I did this I had seen an alternate way of doing it.
>
>CASE WHEN works fine but its bothering me that I can't remember where I saw this and I figure only other VFP folks would know what I'm talking about.
SQL 2012 has IIF and also choose
See
http://technet.microsoft.com/en-us/library/hh213019.aspx
If it's not broken, fix it until it is.
My Blog