Thanks stax68 that is exactly what I am after.

Thanks for all the help for all those who posted.

Craig

Muliple View are not a feasible option. The WHERE cause is being built dynamically on a web page and the number of columns possible are over 20.

Go back to...

Cant do that because the WHERE must be done before the GROUP BYs that the VIEWS contain(granualarity of data issue).

I know it sounds like a job for a SP but...

Brian thanks a lot that answer is a life safer.

My only other issue : Does account with datareader have enough access to execute it. My initial test seems to...