Hi

I want to update a table.
I want to edit a column but all the rows must change

EG.

--A-B-C
X-2-4-1
Y-3-3-1
Z-4-5-1

the Table above, I want to use a single command when row "X,Y, and Z" in column "A" change to 0.

I know its not much of a table but im sure yourl will get the idea

Please help somebody...Im new to SQL

Last edited by Neverdiez; 10Sep2008 at 12:33.. Reason: Table went off