>Hi everybody,
>
>I have a complex SQL statement consisting of
>
>select * from (first select statement UNION another select UNION another select...) order by
>
>This is defined as a string property of my page class.
>
>Now, I have a field IsActive and in general I want to only select active people. So, I can add condition IsActive = 1 to all union statements.
>
>However, I added a new condition to our SQLQueryBuilder to be able to show inactive people or all people regardless on the status.
>
>The question is - how should I handle this situation now?
>
>Check my query_str for the IsActive in it (BTW, when I tried to see Help for IndexOf it opened some unrelevant content after I pressed F1 in VS2008 having IndexOf highlighted) and add this condition if it's not there - but how then both cases should be handled?
>
>Do you have any good ideas for me?
>
>Thanks in advance.


Use a parameter (tinyint) in your query that will show you what you want, That parameter will accept 3 values:
0 - Inactive
1 - Active
2- all
Then build your where clause that way:
WHERE (@Parameter = 2 OR IsActive = @Parameter)