How use an update query to make all prices 0.0000

I have a table that has a price_ea field and in this table some of the records have a value in this field.  But I want to update all of the prices to 0.  How can I do this with an update query?

--Steve
SteveL13Asked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
UPDATE yourTableName
SET [Price_ea] = 0

But this will set ALL of the prices to 0.  If you only want to set those that don't already have a value (where the value is NULL), then you would use:

UPDATE yourTableName
SET [Price_ea] = 0
WHERE [Price_ea] IS NULL
0
 
mbizupCommented:
Update yourtable
Set yourfield =0
0
All Courses

From novice to tech pro — start learning today.