Find the right column

[Dennis Fürbach]

Hello,

I have a SQL database with many tables.
Articles are maintained in the database where a cost center is stored.
I know about the article already the right cost center (4222211) and can narrow down the tables in which the value should be, how can I get out now in which table the value occurs, so I can work with it?
What needs to be done instead of the * so that I get the right table?
So far I have the following:

 

SELECT Table_name, Column_name

FROM INFORMATION_SCHEMA.COLUMNS

WHERE

Column_name like ‘%Artik%’ and

* like '%4222211%'

 

 

 

I would like afterwards the table name and the column name in which this value stands.

 

[justsomeguy]

What specifically are you looking for other than the column name?  What's the other condition in the where clause that you're trying to check?