>Hi All -
>
>I need to update a specific row within a table something like this:
>

>UPDATE mytable SET myfield = 10 WHERE (ROWNUMBER = 4)
>

>but I can't find a good way to identify the row. I've looked at ROW_NUMBER(), IDENTITY(), and RANK(), but none of them seem to fit. Could someone explain how to do this?
>
>Thanks

MSSQL since version 2008 has uncommented pseudocolumn %%physloc%% (type is varbinary). This pseudocolumn is pointer/address to row and it's equal to ROWID on Oracle and RECNO() in VFP.

MartinaJ