Re:Newbe question

From: Vishal Parkar (vgparkar_at_hotmail.com)
Date: 04/30/03 

Date: Wed, 30 Apr 2003 06:14:01 -0700

basically you'll have to fire an update query to achieve
desired result set

eg
update table set col3=col2

--above update will copy content of the column col2 to col3
--now to empty column col2 you'll have to fire following
--update statement

update table set col2=null

--Vishal

>-----Original Message-----
>Hi
>
>I have a table with 3 columns.
>The first column is an ID column with identity on (seed
1).
>The second column contains data that I want to move to
the third column.
>The data that is moved should be in the same row as
before.
>When the data has been moved then the second column
should not contain any
>data at all (but still exist).
>
>Any ideas?
>
>Regards
>Rickard
>
>
>.
>