How to split text into two fields

[SmallTime]

Hi all,

I’ve been given a table of addresses (TblAddress) that has the door number and street name in the same field eg. 123 Howard Way (the field is called address2). I want to move the door numbers to a new field that I’ve created (No) in the same table.

Could someone show me a simple way to do this?

Regards

 

[Crowley16]

update tbl
set no = left(address2, ' ')
set address2 = right(address2, ' ')

remember to back up before you do this...

--------------------
Procrastinate Now!