Josselin wrote:

> happy visitors of Paris know about the 'arrondissement', an
> administrative division of the city... 20
> selecting them from a city database brings them as
>
> 'Paris 1' , 'Paris 10' , 'Paris 11' , ..... 'Paris 19' , 'Paris 2' ,
> 'Paris 20' , 'Paris 3' , .... 'Paris 9'
>
> is there any way to get them ordered as :
> 'Paris 1' , 'Paris 2' , 'Paris 3' , .... 'Paris 9' , 'Paris 10' ,
> 'Paris 11' , ..... 'Paris 19' , 'Paris 20'
>
> if not I'll sort the results after selection... :-(((
>
> thanks for your lights
>
> joss

Remove 'Paris' from the arrondissement field