use Your_database
go
select 'select * from ' + t.name + ' where ' + c.name + ' = ''chicken'' union '
from sys.tables t join sys.columns c on t.object_id = c.object_id
join sys.types tp on tp.system_type_id = c.system_type_id
where t.name = 'budgets' -->your 1500 column table name goes here
and tp.name in (
'text',
'ntext',
'varchar',
'char',
'nvarchar',
'nchar'
)
run this then copy the result of the query, remove the trailing union.