>>>Fabio,
>>>
>>>>you are right,
>>>>because VFP0 start with a bad order by choice, Aleksey and Sergey want defend it.
>>>
>>>Hah? Where did I defend it? I explicitly stated that I don't like it. But that's no reason to call it a bug as you contionue to insist.
>>>
>>><snip>
>>
>>Sergey, we have different opinions,
>>but I do not understand why you want to convince Cetin.
>
>I'm not convinced:) It's a bug IMHO. But I think 2 things are mixed in this thread.
>1) A query like this give error:
>
>select distinct city, right(rtrim(city),2) as country from customer order by country
>
>This is a newly introduced bug IMHO.
>
>2) In previous versions only ordering was done depending on base table field country.
>
>This was a bug in previous versions that might not be accepted as a bug (to ANSI SQL it's a bug).
>
>Now VFP9 solved ordering bug introducing an error!
>Cetin

Perfect!