This is another method that works for character data http://beyondrelational.com/blogs/madhivanan/archive/2009/12/14/search-a-value-in-character-column-of-all-tables.aspx...

Yes it is difficult but managable. You need to make use of single quotes effectively if the procedure code has some dynamic sql...

Sudeep Raj, As long as % is not used at the begging it is fine...

This is a Dynamic PIVOT which can be used if there are unknown number of values http://beyondrelational.com/blogs/madhivanan/archive/2008/08/27/dynamic-pivot-in-sql-server-2005.aspx...

Chintak Chhapia , Yes you can also use that query ...

Thanks Brad, I corrected the code. It should be based on product_id=3...

Thanks Nakul. That was my point too...

Nakul Thanks for the testing...

Thanks Dattatrey Sindol ...

nakul_vachhrajani, Yes. That is easy in one line. But note that sp_MSforeachtable is undocumented and can be removed from future release...