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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Breaking up fields in a table
Thanks hneal98 for such a promt answer, however i am not sure I understand your answer. forgive my ignorance I'm new at SQL server 2k Is it an update statement? will that work for all rows in my table in one statement? Can I do it through DTS where I can save the package for future use? I...- Dave5430
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Breaking up fields in a table
I have a tble that contains a Phone_number field That I want to break it into two fields AC and Number Phone_Number ----> AC Number 4041234567 404 1234567 Can anyone please tell me how to do this, I would really apreciate it. Thanks, Dave5430- Dave5430
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
