>Hi all ,
>
>Is there any other way of updating a 200 column table without refrencing each individual column in the update statement..................!
>
>Help would be highlu appreciated.
>
>Colin

Colin,
What do you mean ? If you'd update only 3 columns :
update myTable set f1 = v1, f2 = v2, f3=v3 where ....
Cetin