How to search specific word or text in Database object ?

Today i am posting very basic but very important topic and that is “How to search specific word or text in Database object ?”. Everyone who is using MS-SQL at least once they have already faced or will face a situation where they need to find out that How many times and where in the Database objects a particular text or word has been used? For example I use a WHERE clause like “where Product.amount >= 1000″ in my store procedures and this kind of WHERE clause is using into 40 store procedures in my database and in my database i have more than 500 store procedures .One day i get situation that i need to update this WHERE clause and that will be like “Where (Product.amount + Product.XYZ) >= 1000″, Now what would i like to do to change this Where clause in all my 40 store procedures.