View Single Post

   
  #1 (permalink)  
Old 02-28-2008, 08:48 AM
Josselin
 
Posts: n/a
Default 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


Reply With Quote