>When I issue a sqlexec() with a select statement like:
>
>select * from Contact1
>
>It brings over all of the fields and all of the records, even the records marked for deletion. Is there any way to prevent the deleted records from being brought over?
>
>DJ :o)

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