Originally posted by Ovidiu
theguru, this is only an example.
In real table col_1 contain data which is input by the users and the value is not A,B,C....., the real col_1 is with other values.
Take all the distinct col_1 values along with col_2 values to be assigned in a temp table,
and update original table joining on col_1 of orginal and temp table.
try this or could u plz send sample data so that i too can try it out.