>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

You need a key somehow. This isn't VFP. What are the field values that make your 4th row unique? Make them the where clause.