>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.
I doubt this is it....but there's a COALESCE....that will return the first non-null...
COALESCE( Col1, Col2 , Col3, Col4, 'default')
That's the equivalent of...
case when Col1 is not null then Col1
when Col2 is not null then Col2
when Col3 is not null then Col3
when Col4 is not null then Col4
else 'default' end
Again, I doubt that's it, but it's the only one off the top of my head. Maybe someone either has a better memory, or can interpret your dream :)