Accept parameters in the combination of columns for retrieving many records

Table1 has 4 columns = Col1 , Col2 , Col3 , Col4

Col1 is id(integer) column = 156 , 159 , 175

Col2 is varchar column = CAA , DFE , EME

Col3 is varchar column = 12345 , 23465 , 43122

Col4 is varchar column = 2 , 3 , 6

I am creating a stored procedure which accepts collection of combinations as parameters

Combinations = Col2 + Col3 + Col4 which returns Col1 value. Similarly to accept collections and returns many values (Col1)

For Example : Need to get the inputs CAA + 12345 + 2 has to return 156. Similarly DFE + 23465 + 43122 has to return 159.

How to accept parameters in the stored procedure for the above scenario? How to accept parameters in the combination of columns for retrieving many records in SQL Server?

Answer

I have explored and found the solution.

I have created a table type – having 3 fields

Then, I have used this table type in the stored procedure accepting as a parameter

Then, I have used inner join to accomplish my task.