Easy way to swap column info. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Easy way to swap column info.

Author

Topic

abarsami
Yak Posting Veteran

68 Posts

Posted - 2001-08-10 : 13:10:15

I have a first name column and a last name column full of 200 records. Is there a easy way to swap the records ... so that the info. in the first name column is now in the last name column and vice versa.

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources