I have street addresses in one field, which includes the number and the name.
I want to separate the number of the street address from the rest and have two fields so that sorting will be more accurate.
The numbers are separated by a space in the address.
I would like to do an update query to fix this problem.
Can anyone help ? Or have any other ideas ?