>>
>>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)

Sorry, my brain wasn't in gear. I was thinking VFP sql, didn't even register it is doing ODBC. My bad!