Query to find out the some text in the Table data

Question

Hello All,

 

Can you please help us to find out the some text in the Table data.

Let say i have text like "DPSS" I need to find this text in the enter tables in the  Database using SQL Server is there any query to get these details in the entire all tables.

 

please help us.

 

 

Thanks

Anand