SQL search multiple columns for same value code example

Example: sql server check for value in multiple columns

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