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
How about: BEGIN TRAN UPDATE dbo.tbl SET AC=LEFT(RTRIM(LTRIM([Phone_Number])),3), Number=RIGHT(RTRIM(LTRIM([Phone_Number])), LEN(RTRIM(LTRIM([Phone_Number])))-3) WHERE LEN(RTRIM(LTRIM([Phone_Number])))>3 COMMIT TRAN- qwertyguy
- Post #4
- Forum: Microsoft SQL Server: Programming
-
union statement
Not only do the fields have to be the same type, since you are aliasing the field names, the fields have to be identical in name as well- qwertyguy
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
