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.