>>My client has a table called CompassQueries which stores WHERE clauses:
>>
>>

>>ID            CampaignId   Query
>>----------------------------------------------------------------------------------------------------------------------------
>>425         140               [Assembly]='151' AND [Party]='R' AND [Propensity]='4'
>>429         140               [Assembly]='151' AND [Party]='R' AND [Propensity]='3'
>>430         140               [Assembly]='151' AND [Party]='R' AND [Propensity]='2'
>>

>>
>>So I now need to run a query that returns a DS of voters who match these queryies:
>>
>>It would be the same as running this:
>>

>>SELECT VoterID FROM tblCamp_CT WHERE  [Assembly]='151' AND [Party]='R' AND [Propensity]='2'
>>

>>
>>except the WHERE clauses come from the CompassQueries table for all rows that match the campaign.
>>
>>How do I do this?
>
>
>You will need dynamic SQL here, e.g.
>

>declare @SQL nvarchar(max)
>
>select @SQL = coalesce(@SQL + '
>UNION ALL ','') + 'SELECT VoterID from tblCamp_CT WHERE ' 
>+ Query FROM CompassQueries
>
>print @SQL
>
>execute (@SQL)

Ok, I see what you're doing, excelt what's "Query"?