A previous message in this thread (from Yuri Rubinov) and a little more playing indicates that Nofilter dictates if the original delete state is maintained in the query results.
The SQL in Create View must default to Nofilter...
Todd
The day you take complete responsibly for yourself, the day you stop making any excuses, thats the day you start to the top. - O.J. Simpson
Great advice from a questionable source...
