>Already tried that, thanks. I think we've sorted it by wrapping the select in a SET DELETED ON. Although that had to be done in the grid that receives this command (complicated framework issue).
>
Using SET DELETED ON is your only option if you want to use a single SELECT statement. You can't specify an alias for the DELETED() function in a SELECT statement, so it won't work for a multi-table SELECT. It does work OK for a single table one, though.