>I am trying to select either specific records or all records from a parameterized view. In the case of a character field, if the view parameter = "", all of the records are selected. However, if the view parameter is based on an integer field, is there a way to select all the records, when using the equals clause. (or should I try a different way)?
>Thanks in advance
>
>Porter Bailey
To pick a range, use BETWEEN()
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer