Parse House Number from Street Name in Street Adress Field
-
I have a data base that has a VARCHAR Street Address field that contains the House Number or Street Number with the Street Name. I want to create two seperate data fields one with Street or House Number and another field with the Street Name.
Any suggestions
-
Please do not cross-post, we monitor all boards.
Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=194861
-
I would use a simple program that searches through the field for any NUMERIC values at the head of the string (using Char() and the ASCII code) then cut them out and update the new column.
You probably already thought of this
Take care
Troy
-
What about addresses that just have a house name instead of a house number, or have a house number of 35a etc.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply