search single value multiple column in sql code example

Example: sql server check for value in multiple columns

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