SQL Server SELECT where any column contains 'x'

Question

Using SQL Server 2008, say I have a table called `testing` with 80 columns and I want to find a value called `foo`. I can do: ``` SELECT * FROM testing WHERE COLNAME = 'foo' ``` Is it possible I can query all 80 columns and return all the results where `foo` is contained in any of the 80 columns?

Accepted Answer

You can use `in`:

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

SQL Server SELECT where any column contains 'x'

Solution

Problem

Related problems