query to split 1 column and sort

[homer.favenir]

hi to all,
can anyone please tell me how to split 1 column and sort it by splitted column.

i have 1 table with address column. The address column contains strt # and strt name.
e.g.

ADDRESS
123 main st. 
123 10th avenue.

because i need to sort first the strt name before the strt # and before the other columns.

can anyone please....


thanks

 

[mearle]

You need two calculated columns containing some vb functions:
Street: Mid([Address],instr(1,[Address]," ")+1)
StreetNumber: Val([Address])
Then sort on these.