>I had to do something similar. In the view use LIKE for the comparitor.
>then when the user selects ALL pass in % for the value of the parameter.

Kim,

Explain for me what you mean by %. Is it a literal or are you referring
to a wildcard operator? (My keys are integer)

Chris