You could build a temporary table holding the GUID/VALUE pairs.  Then your query could be of the form WHERE a IN (SELECT ... from #temporarytable)