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.