what is the best way to do this.
I have a report in SSRS that will have a drop down that is Active/Inactive/all.
The column in the stored proc to evaluate would be
lactive = 0 (Inactive)
lactive = 1 (Active)
But the user woudl like to let the user select all so that both would be in the query as well.