well there will be alot more rows in my table some will have negwatch some wont so what i need to do is update the MIDIRB rows in the acrt...

ya this is the acrt table now as i have it in our system and negwatch is last column

probably missing the last braket didnt copy and past the lot thought...

sorry put in the older version of table

CNO ...

hi

thanks for response

ok will try post it better

he is the two tables i am actually working of

CREATE TABLE dbo.IRBT

(

MOODYSRATE ...