SQL Server SELECT where any column contains ‘x’

May 28, 2023 by Tarik

You can use in:

SELECT *
FROM testing 
WHERE 'foo' in (col1, col2, col3, . . . );