Lynn...no hard feelings about post on forum but i felt its important to raise a point about using that @temp variable.

here i am not criticizing anyone...but just informing [Smile] and I think purpose of forum is that only!

lets say we have 5-10gb of table in which we want to swap columns, in this case using @temp variable will be too expensive.

guys...I really appreciate the efforts and time you have taken to post here. keep posting... [Smile]