Re: copying field x to field y for each record in table

[Paul DuBois]

At 10:10 -0600 4/3/02, Chuck Barnett wrote:
>Hi, how do I do the following:
>
>I have a table I have added a new field to, I want to take field X and copy
>it to the new field for each record.  What should this query look like?
>
>Thanks,
>Chuck

UPDATE tbl_name SET y = x;