Not sure if there is anything special, but this should work:
update my_table
set my_column = '0';
The '0' is a string or a number? If it is a number, then remove the single quotes around the 0 in the above example.
Also note that the above SQL will change ALL the values in that column to '0' or 0...so if you want it done only for some rows/records, then add a where condition..
HTH,
Shanx
