Searching across 155 tables

I need to search for different names that may or may not exist in each of the tables in a database that contains 155 tables. The fields may not be named the same, and, the search names may exist in several different fields in the table, or not at all. I probably could use a web app to do this but don't really have the time. I remember doing this long ago with such great tools as Tcl, AOLServer, and ADP but I sure don't have time to get into all of that. Any quick ideas just using simple query tools? I downloaded a trial of EMS SQL Query but still have not found the solution...maybe a stored procedure? I am a little rusty with all of this so am hoping there is an easy answer that I am forgetting. Thanks in advance!