The way to do this is with dynamic SQL.
declare @C varchar(500)
select @C = 'Select * from MyTable where '
+ config_value from Config_table
exec(@c)
Be aware that if you are building this string with other values, you are potentially opening yourself up to SQL injection and security issues.
Can I ask why you are storing the WHERE filters in a table?