OK, now I get it <g>
What you actually want to do is use is:
WHERE cPeriod LIKE ?lcPeriod
and then lcPeriod could be "%" when you want to get all periods. The actual answer to your question then should have been that "%" is the wildcard <g> ... but you also have to specify LIKE rather than =
HTH,
~~Bonnie
>Well, I'm actually doing this with a graphical view....I have a remote view with the parameter of cPeriod c(20). Most of the time, I want to only retrieve data with one particular period. However, I had hoped to be able to pass, rather than the specific period, a wildcard to indicate the whole file should be retrieved. The alternative to this is to create an identical view without the parameter, but that seemed inefficient to me. Normally, I would do just that, but the view is full of joins, etc, which (to my knowledge) must be manually copied into a new view.
>
>Hope that clarifies things a bit. If I'm doing this all wrong, I'm definitely open to better suggestions!