>Hi
>
>I'm working with a view using multiples parameters.
>Sometimes I need to use one parameters and sometimes another. How can I do that?
>
>TIA

Steve Dingle was just talking about how he does this over on CompuServe. He's defined his view where the entire WHERE clause gets macro expanded. For example:

Select whatever ;
   from some table ;
   where &lcWhere

and then he defines lcWhere at runtime.