Hi Lutz,

It seems I didn't make myself clear enough.

This is the case when the exact value used for an update is unpredictable: can be 100 or 200.

In this particalar SP this uncertainty is acceptable; that's what I meant by 'don't care' - nothing to be scared about and no need to modify the query.

My question is: if this query is run in a different environment, with different ANSI (or else) settings, is there a chance that the existanse of multiple possible values for the update would raise an error? I am only concerned about having an error; I am OK with unpredictable update result.

Cheers.