uniqueness in similarity?

[moonguy]

i have a table in sqlserver which has only one column,say name

select * from table_name;
returns

anil
vijay
anil
anil
vishal
anil
mohan

if we want to delete the 5th anil name (through query analyser)
how to do it
if i use newid() function
it always changes.
thank you

[Jethro]

Dim sSQL as String
Dim rsTable as recordset

sSQL = "select * From table_name"

set rsTable = dbname.openrecordset(sSQL)

rsTable.FindLast("Name = 'anil'")
if not rsTable.EOF then  rsTable.Delete
rsTable.MoveFirst

Do you mean specifically the fifth occurance, or the last occurance of "anil"