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?