Originally posted by football
Mirsat89 solution is fine if there is a 'key' field in the table. But unfortunately my table doesn’t have a key field.
Uh, you may want to do something about that. [B]Every[B] table needs a PK. If you don't have a 'natural' candidate key then make a surrogate one (actually, should always use surrogate, IMHO, but that's for another time).

- Chris