I want to use Parameter in Trigger or Stored procedur to manipulate query's where clause like a lexical parameter of Reports

If any one can help me
I will be thank full to him


Thanks