Good Man wrote:

> "strawberry" <zac.carey@gmail.com> wrote in news:1166629014.665983.254180
> @i12g2000cwa.googlegroups.com:
>
>
>>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
>
>
> and make the arrondissement field a numeric field (unsigned 'mediumint'
> will probably do)

or modify your data 'Paris 1', 'Paris 11' or 'Paris 001', 'Paris 011', Paris 100'

--
Michael Austin.
Database Consultant