Strange behaviour of SORT

Here are two queries and their results : I can't explain the differents sort orders.

1- Sorting with GROUP BY
select hierarchie from f
group by hierarchie

Result :

1
11
111
1111
1112
1113
1114
1115
1116
1117
1118
1119
111A
111B
111C
111D
111E

2- Sorting with ORDER BY
select hierarchie from f
order by hierarchie

Result :

1
11
111
111A
111B
111C
111D
111E
1111
1112
1113
1114
1115
1116
1117
1118
1119

Thanks for help

Olivier. Received on Thu Mar 11 1999 - 07:58:59 CST