SQL select using filters saved in a table

Question

I have a table in which filters to be used in a select statement.
The table looks like this:

How can I use this column values in a select statement?
The table where I am using select statement cannot be joined with this filter table.

Answer 1

Hi，@Hema Ramachandran

Welcome to Microsoft T-SQL Q&A Forum!

I agree with ErlandSommarskog's point of view for your case.
I did some tests, but when querying sql, only the results of concatenating strings are displayed, and the filtering results are not displayed as expected, can you explain why you need to use filters here Table? In my opinion, this is just a multi-table connection, only need to add filter conditions after where.

Best regards,
Bert Zhou