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.