Actually I do care what the values are (for the most part) but those that are duplicate need to be set to a high number. I found that I can do it in 3 DO WHILE loops. But I thought that there had to be more efficient method. So I suppose I will have to live with my 3 loops. Thank you.
>If you don't care what the values are, why don't change all of them in SCAN loop starting wit 1?
>
>>
>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham