sorting alphanum colum .. 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 |