single quotes to strings in t-sql

I just want to know that is there any shortcut to automatically add quotes to each string in IN CLAUSE?

For ex: I got more than 10 tables to check IN CLAUSE

select * from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME in (dimproduct,dimproductCateogory,dimproductSubCateogory,FactInternetSales)
and COLUMN_NAME like '%eng%'

in the above example I want output like this: adding single quote to each string

where TABLE_NAME in ('dimproduct','dimproductCateogory','dimproductSubCateogory','FactInternetSales')

Thanks in advance


Download single.quotes.to.strings.in.t.sql.zip
Direct Link


Download


Download single.quotes.to.strings.in.t.sql.zip
Mediafire


Download


Download single.quotes.to.strings.in.t.sql.zip
Gboxes


Download


Download single.quotes.to.strings.in.t.sql.zip
Bayfiles


Download


Download single.quotes.to.strings.in.t.sql.zip
Wupload


Download