sql server (microsoft): Hello,

I want to use SQL Query analyzer to...

For a group of records matching a specific criteria I want to move
values from Field1 to Field2 and change Field1 to Null.

BTW: Is this the right news group for SQL questions?

Thank you,
dbuchanan

[quoted text, click to view]

Like this:

UPDATE your_table
SET col2 = col1
col1 = NULL
WHERE .... ?

[quoted text, click to view]

This group is virtually dormant. Much more active groups are in
microsoft.public.sqlserver.* . You'll find you'll get more help in
microsoft.public.sqlserver.programming for a question like this.

--
David Portas
SQL Server MVP
--