>>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.
Thanks William.
My table has a fixed number of rows so I just added another column with rownumber. It seems to work OK. I was just hoping to make it a little simpler with a function like RecordNo().
Thanks for the clarification.
And now my mantra "Why 'O Why can't MS make SQLServer/NET as easy as VFP?" They should get Calvin and Levy on the team.