CODE EXAMPLE FOR SQL

sql server check for value in multiple columns

SELECT * FROM table WHERE 123 IN(col1, col2, col3, col4);