Repairing data

[Steffan A. Cline]

I ran into a situation where upon importing a client's data I noticed that
they had in address field "123 easy street #600". Is there a query I can do
to take the field address and truncate the #600 and stick it into the field
"address2"? I am sure it might take some regexp or something but its a bit
over my head. 

Any suggestions?


Thanks

Steffan

---------------------------------------------------------------
T E L  6 0 2 . 5 7 9 . 4 2 3 0 | F A X  6 0 2 . 9 7 1 . 1 6 9 4
Steffan A. Cline
Steffan@stripped                             Phoenix, Az
http://www.ExecuChoice.net                                  USA
AIM : SteffanC          ICQ : 57234309
The Executive's Choice in Lasso driven Internet Applications
                                  Lasso Partner Alliance Member
---------------------------------------------------------------