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