I'm working on a database, where I got a situation to search for a keyword (that may be either name or address or city etc). And now I need to create a Stored Procedure to make search in all the tables of the database..!!

Can anybody help me out of this plz..!!