On 4-11-2013 15:52, checkmail wrote:

>
>
> Hello,
>
> I would update a table (Primary key year and number), all records with
> the same ordernumber for example – but not the record where is currently
> in use and already updatet.
>
> Update table set field = value where ordernumber = XXX and (not record
> with year 2013 and Number 1)

You just need to use the right syntax for the condition:

Update table set field = value
where ordernumber = XXX
and not (year = 2013 and Number = 1)

Mark
--
Mark Rotteveel