Home > IT Answers > Development > Address segregation in SQL 2005
Dkrueger
25 pts.
 Address segregation in SQL 2005
SQL, SQL 2005, SQL Address Segregation
I am working in SQL 2005 and would like to parse an address filed such as "1234 N CLARK ST APT 111 " into seperate fileds like House Number/Street Name/Street Type ie LN ,ST, or Cir/Apartment Number

Software/Hardware used:
ASKED: February 5, 2009  8:30 PM
UPDATED: February 6, 2009  12:15 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You need to program a string parser and insert the parsed items into your database. SQL does not have parsing methods that I know of.

mshen
 27,310 pts.