i need it on the when statement because if changes where made then i give the user the ability to Cancel and return back to the grid for updating. So the WHEN statement is the best for doing this. thanks for your suggestion.