extract numeric part from address

From: David Chang <chang_dj_at_yahoo.com>
Date: Tue, 10 Feb 2004 09:06:13 GMT
Message-ID: <8a1Wb.209671$Rc4.1720145@attbi_s54>

I am trying to do some analysis on customer's locality, so I'd like to extract numeric part from address.

Here is how the table looks like

Table Member

first_name    last_name    address1                            address2
state    zip
=======     =======    ===================    =====    ===    ===
Tom            whatever        1200 Evelyn Ave, #121

CA 94102

What I want to do is to write some sql to extract 1200 from Tom's address1. Can any one give me some hint? Some sample code will be greatly appreciated !!

David Received on Tue Feb 10 2004 - 03:06:13 CST