SQL Help

Soldato
Joined
13 Aug 2004
Posts
6,788
Location
Bedford
Say I have an address like

54 Solent Gardens

in a column in my database. How would i go about cutting it and move the Solent Gardens bit to a different column?

Halp
 
they are all [number] [place]

however, some numbers can only be one digit i.e

8 test drive

and soem can be

84 test land
 
Hi

thanks for the help

is it possible to leave house number in the field it exists at the minute and simply cut the sstreet name and move that ?
 
Back
Top Bottom