I'm in the process of converting an old Access2 database to SQL server 7 and have come accross this query :

DELETE DISTINCTROW BOTrans.gl_tran_code, BOTrans.MatTest
FROM BOTrans
WHERE ((BOTrans.gl_tran_code) In ('stoki','stokr','stokx','wrton','tfer',"gjnl","jnal","jnye","jnye2","jnye3"))

It LOOKS like the person that wrote it was trying to delete only certain fields from the table, which I would normally use an update query for. Can anyone tell me if this delete query is (was)actually valid and if so what would it do ?

Thanks in advance
Ian.