SQL Update Statement for first N rows?

[rstrong]

Hey

I am having some trouble writing an SQL command. I need to set a field in the first N entries of a table. I thought it would be something like this:

UPDATE TOP N table SET field1 = 'whatever'

but it doesn't work. It seems I can't use TOP with the UPDATE statement. Is there something else I can use?
Thanks.

 

[r937]

how do you define "first"? in relation to which column?

r937.com | rudy.ca

 

[PHV]

A starting point:
UPDATE table SET field1 = 'whatever'
WHERE PrimaryKey In (SELECT TOP N PrimaryKey FROM table ORDER BY 1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886