Update top record only

[James1981]

Hi,

I want to update 1 record in a table based on a where clause that will return more than one record.

I suppose it is similar to a SELECT TOP 1 field FROM table statement.

Does anyone know if it is possible to use the TOP keyword or is there a more complicated way of doing it?

Thanks

James

 

[r937]

update yourtable
set foo = 'bar'
where id = ( select id from ... )


rudy