>
>Select * from mytable where this=that and not deleted()....

This only works when you are doing selects-sql within foxpro. When you use sqlexec() you cannot pass the deleted() function that I know of. However, Matt came up with a solution. Turn show deleted rows off in the ODBC driver. That solved the problem.

Thanks for giving this some consideration though.

DJ :o)