>Hey Sergey!
>
>That's what I've been typically been doing, but thought in the back of my mind, what if I screw up. I almost screwed up today.. lol. I'm currently dealing with an app that screws up so much, I have to go into SQL Server and realign the records.. it takes up so much time that I can't fix them! But I'll find the time. In the meantime, I think I'll just work through FoxPro (which the company hates for some reason), before I commit changes.
>
>Anyway, I looked at your website. Very cool!
>
>Thanks,
>Dan
>
>
>>I use a query to make sure that conditions are correct and then replace SELECT with DELETE

Dan,

A quick way is to start a transaction before deleting. Then before closing the transaction you can perform ad-hoc queries to double-check. Once you are satisfied with the results, commit the transaction. Do this all in the same query window.

- Keith