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_at_attbi_s54>
I am trying to do some analysis on customer's locality, so I'd like to extract numeric part from address.
Date: Tue, 10 Feb 2004 09:06:13 GMT
Message-ID: <8a1Wb.209671$Rc4.1720145_at_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, #121CA 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 - 10:06:13 CET