Thanks Mr Arnon and everybody,
This will definately work... Thanks..
>>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...
>
>you have several options for example
>
>SELECT .. WHERE (?tiFilter=1 and DELETED()) or (?tiFilter=2 and !DELETED()) or (?tiFilter=3)
>
>
>Arnon