Thank you, I think I will write a generic SQL function to access these variable groupings which will return a SQL string which can then be executed.

Thanks for the clarity.