[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Multiple parameter for WHERE clause



Hi

   I have a PeopleSoft report which can have multiple parameter that can
either be used or not depending on the users preference.
ie: If a benefit plan is entered use the code specified else use all benefit
plan. I have around 6 different options like this.

I am wondering what would be the most efficient way to code this type of
specification??

Thanks