I have 11 Columns; let’s call them Column1…..Column11. Let’s say all those 11 columns house employee names. I’m trying to look for a specific record in all those 11 columns, but here’s the problem, some column house only last name, some last name and middle initial, some have last name and the middle name spelled out, and some have the full name.
So, I’m trying to find a better way to query all the tables.
What I’m currently doing is:

Select

Column1, Column2….Column11

From

Table

Where

Column1 like ‘Beatrice%’
OR

Column2 like ‘Beatrice%’
OR….

Column11 like ‘Beatrice%’

Is there a short query I can use like ‘IN’ with wild card?

Where

‘Beatrice%’ IN (Column1, Column2,… Column11)

I know this query won’t work, but I’m wondering if there is a shorter way to query the tables without having to use 11 “likes” with 11 columns