Need to check for a column in a table

[TalkVirginia]

Thanks! This looks a bit easier than what I was originally toying with. I was trying to do it with a table join to itself in an update query.

Something like:

UPDATE TABLE_NAME as T2
SET t2.NEW_COLUMN = t1.OLD_COLUMN
INNER JOIN TABLE_NAME T1
ON T2.UserID = T1.UserID
WHERE T2.UserID = @UserID

I just wasn't able to figure out how to loop it to get the userid.