>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement
Click here to load this message in the networking platform
