for a specific value of "ABC" cparam = "ABC"

for all values that start with an "A", cparam = "A%"

for all values cparam = "%"

SELECT * FROM table WHERE column LIKE ?cparam

>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!