>>>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
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only
Click here to load this message in the networking platform