Actually I want to update by set command for multiple rows containing the ACTCODE in a sequence like (001, 002, 003 ETC) with the sample provided earlier.

Sample Data, ACTCODE datatype nchar(6)

ACTCODE ACTDESC

110001 J's Dream

110003 FPAB

110009 Jharna Dhara

(Where ACTCODE BETWEEN 110001 AND 110009)

will be updated with different ACTCODE in a sequence with incremented by +1

220004 J's Dream

220005 FPAB

220006 Jharna Dhara

By set command