>I think that's where the problem may lie, you either need the filter (or SET DELETED ON) to get the expected behaviour. One way or another, you've got to stop the SQL for the view returning deleted records from the base table.

Sorry, I should have said, I have got SET DELETED ON, I just haven't got it filtered in the view.

Kev