LOOKUP(ReturnField, eSearchExpression, SearchedField [, cTagName])
SELECT LOOKUP(...) AS MyField ...
>>Cindy,
>>
>>Actually, I tried that, but could not make it work. Could you please show me, how the code should look like it be in my case?
>>
>>Thanks in advance.
>>
>>>Nadya,
>>>
>>>One more idea (for the future) would be to use the LOOKUP() function, as long as you're working in VFP.
>>>
>>>
>>>>>Maybe try by dropping the DISTINCT and add a GROUP BY CCODE clause at the end.
>>>>
>>>>This solved the problem.
>>>>
>>>> select nvl(State,lcState) as State, ;
>>>> nvl(upper(County),lcCounty) as County, ;
>>>> lcCity as City, ;
>>>> curTemp.ccode, curTemp.town, UseGrp, cYear, ;
>>>> VolSales, MedSale, NumSales ;
>>>> from curTemp left join Towns on curTemp.ccode=Towns.ccode;
>>>> group by 4,5,6,7 ;
>>>> into cursor curWork
>>>>
>>>>Thanks to everyone.