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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Data parsing
Thank you, I will give it a shot.- jose1024
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Data parsing
I understand about the copying of the zip to new field, but I am not sure how to delete it from its existing location. If I use the left or substring function, how do I determine the length? You said to use 5 as my length, could you expound on why to use 5?- jose1024
- Post #5
- Forum: Microsoft SQL Server: Programming
-
-
Data parsing
I have a column that contains city, state zip data. I need to place city and state in one column and zip in another. The field is 25 characters in length and obviously, the city varies in length within the field. I am using Transact SQL in SQL Server 2000 Query Analyzer. Any suggestions...- jose1024
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
Parse data within one column
I have a column that contains city, state zip data. I need to place city and state in one column and zip in another. The field is 25 characters in length and obviously, the city varies in length within the field. I am using Transact SQL in SQL Server 2000 Query Analyzer. Any suggestions...
