Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Dishman
-
SQL Address Parsing Routine
Well Donutman I would happily give you a dollar for a good parsing script that takes into account that the address does not come in any specified format. It could be 100 W. Main St, P.O. Box 100, 100 West Main Street Apt. 10, etc. That is my true battle which I guess was not properly specified...- Dishman
- Post #3
- Forum: Microsoft SQL Server: Programming
-
SQL Address Parsing Routine
Does anyone know of a SQL address parsing tool or have code for parsing address data. For Example: 100 West Main St. parsed into 3 separate variables Street Number, Street Name, and Street Type. I need this for an inhouse project where we need to match incoming patient data from many different...- Dishman
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
