I sure can't duplicate the problem on some test data regardless of the settings of ANSI and EXACT.
How big is pricelist.dbf. I want to run the SQL statement on my set up to see if I get the same results. If a zipped version of the DBF (all I need is the 4 listed fields) is less than 500k just send it to me as a e-mail attachment. My e-mail address is doresvei@halcyon.com.
If you find a solution in the interim, please post it so we all know what to look out for.

>I tried your suggestion to no avail. My SQL statement now looks like this:
>
>SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
> FROM price!pricelist;
> GROUP BY pricelist.ITEM;
> ORDER BY pricelist.DATE DESC;
> INTO TABLE temp.DBF
>
>Any other suggestions???
>
>
>>Strange behavior.
>>May I suggest:
>>1. Swap the order of the GROUP BY and ORDER BY clauses.
>>2. Refer to the GB and OB fields by number as in
>>
>>SELECT .... GROUP BY 1 ORDER BY 4 .....
>>
>>Good Luck.
>>
>>>I have the following SQL statement:
>>>
>>>SELECT pricelist.ITEM, pricelist.REPL, pricelist.price, pricelist.DATE;
>>> FROM price!pricelist;
>>> order by pricelist.date desc;
>>> GROUP BY pricelist.ITEM;
>>> INTO TABLE temp.DBF
>>>
>>>The results do not show an item number:
>>>
>>>T97000-503
>>>
>>>but it will show an item number:
>>>
>>>T97000-503R
>>>
>>>What may I be doing wrong?
>>>
>>>Jeff Pearce