Yes I understood that part. As you said if the column does not exist in sys. columns i can exclude it from teh update. What if i want to include it in the update? how can I do that?

Eg:The parsed values table has

FieldName value

"Name" "Bob"

The destination table has column "CustomerName". In this case, the value "Bob" should be updated to the column "CustomerName" but the Parsed table FieldName is "Name". How can I use the columnname "CustomerName" in my dynamic query whenever there is a fieldname "Name" in the parsed table? Can I have a file which will have data like

DestTableColumnName ParsedTableColumnName

"CustomerName" "Name"

Can I read from such a file or table and update the corresponding column?

Pooja