Sql server USP to find a column text in a cell and insert true or false in the respective cell

See more:

SQL-Server-2008R2

Hi, I'm trying to write a USP to search a string which is a column name in another column's cell and if the search keyword is available in the Searched column then for the respective row it should insert 1 (true) , if not then 0 (false).

Let me elaborate it:
My table (SearchableTable):

ID	ArticleColumn	                       Installed	Proactive	process 
234	That was installed on client machine.	1	        0	        0
235	Preparation for all above	            0	        0	        0
236	A proactive process of installation.	0	        1	        1
237	the process in a different way.	        0	        0	        1

The logic:

ALTER PROCEDURE [dbo].[SerachColumn]
AS
BEGIN

	-- GET the 1st searchable column name 
	-- Search it in the 'ArticleColumn' column
	-- if found insert 1 in the respective cell or 0
	-- Do this for rest of the columns
	-- when the columns finish come to the next row 
	-- and search the 1st column name again in the respective 2nd row of the 'ArticleColumn' 
	-- repeat the process till all the searchable columns and rows finish.
END

Please help.