>>>>>select ICASE(intSaleType = 1, 'Sales, IntSaleType =2, 'Return','Something else') as SalesType from
>>>>
>>>>This time I beat you to give the... WRONG answer, fortunately Sergey does pay attention :)
>>>
>>>Why - I think your answer is correct. Unless he uses VFP8, in this case the nested IIF.
>>
>>You are still not paying attention :) The version posted by Tommy IS VFP 8 SP1
>
>I did - that's why I put VFP9 in my response.

I'm curious.............

I can understand posting both versions but why would you post only a VFP 9 answer when you knew the post was for VFP 8?

Click here to load this message in the networking platform