>:-)
>I don't know what she wants as a result :-)
>That select will return every record where @TotEAP between AdjLow and AdjHigh :-)
>So she will update the whole table with the last result from this query (and it could be random).

Exactly, but I think it will be first random value.