I'm considering moving an app to SQL Server. Whereas VFP has the ability to see a deleted record simply by setting DELETED OFF, how does SQL Server handle deleted records (is there even a "deleted" record concept in SQL Server)?

Thanks,
Bill