hi all:

when i use SQL SELECT to select records from a table, i end up retreiving the deleted records too although SET DELETED is ON. how do i overcome this problem ?

thanks in advance.