>Hi,
>
>Say I have a table that has column MY_INT_FLD I(4). There could be some records in this table that have the same value in this field. And some records that have 0 in this field. I want to create one or two (or maybe even three) UPDATE command(s) that will set each record of this table to a unique value and it has to be greater than 0. Is it possible? TIA.

Try:

update myTable set Field = Field + 1000  + recno() ;
where Field in (select Field from myTable ;
group by Field having count(*) > 0) 

I add 1000 assuming that the total number of records is less, so we always end up with unique values after update.