>>I want to set a Filter in View through Which I can either
>>choose to :-
>>
>>1. Select all records
>>or
>>2. Select only deleted records
>>or
>>3. Select only undeleted Records
>>
>>Any suggestions/ideas ??
>
>either you add a field to your view
>SELECT .. DELETED() as lDeleted
>
>or you can make this a parameter in your WHERE
>and REQUERY as needed
>
>Arnon

Thanks a Lot for both of your suggestions...

I'll prefer to do it with WHERE Clause... But not able to form it properly...

Can you pls tell me how to do exactly through where clause...