Thank you ! i hadn't thought about checking the MSDN page of the update function.

I'm not trying to do anything with this query. while working on an update i just thought of what would happen if there were duplicates and tried it to check it out.

thanx again for the answers