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