Do you want this?

update table1 set
table1.column1 = ...
where
table1.id = (select first 1 t.id from table1 t ...)

Regards,

Fabiano

On 10/10/07, Mr. John <mr_johnmr@...> wrote:
>
> Hi !
> I'm looking for a solution how to update only first matching row for a
> condition.I know that UPDATE ..FOR <criteria> won't work.
> Thanks.
>
> __________________________________________________________
> Yahoo! oneSearch: Finally, mobile search
> that gives answers, not web links.
> http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]